MySQL database - Adding New Data Source 'Access denied for user'
I am trying to install MySQL on my machine at the moment.
I have downloaded the file mysql-essential-5.0.21-win32 from the MySQL website and installed it. I then downloaded MySQL Control Center, which came zipped in a folder called mysqlcc-0.9.2-win32.
I have installed both applications and I have a MySQL database which I have acquired from elsewhere. I copy/pasted it into my C:\Program Files\MySQL\MySQL Server 5.0\data directory, but when I try to add a new database in MySQL CC it doesnt allow me.
I have also installed the ODBC for MySQL (called mysql-connector-odbc-3.51.12-win32). However, when I try to add a new data source in the Control Panel I get this error:
[MySQL][ODBC 3.51 Driver]Access denied for user 'versiontwo'@'localhost' (using password: YES)
versiontwo is the name of the database.
the database has a password.
Any ideas? Have i not installed something?
Thanks in advance.
what is the username though? databases don't have passwords in mysql...
the username is 'versiontwo'. i can access the database using command line in windows (Start>Run>'cmd'>mysql etc. etc....)
heres a link to my screenshot of what i am trying to do in the ODBC...
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)