cannot connect with with MySQL root user
Posted 02 October 2003 - 03:29 PM
2nd install went fine, I managed to do a test connect using
I then went ahead and did (as recommended) the setting of the password for the root user via:
And now (just as before in the first install) I can\'t connect to the database using the root user. the following line
[list]/usr/local/mysql/bin/mysql --user=root mysql
comes back with
ERROR 1045: Access denied for user: \'root@localhost\' (Using password: NO)
which suggests that I haven\'t set the password... but I have (see above)
Oddly enough, I can connect to mySQL using the mySQL user (standard in OS X 10.2) via:
but I can\'t really do anything as any attempt to create for example
[list]mysql> INSERT INTO user VALUES(\'localhost\',\'root\',PASSWORD(\'some_pass\'),
results in ERROR 1046: No Database Selected
What am I doing wrong ? help !!!
Posted 02 October 2003 - 04:10 PM
/usr/local/mysql/bin/mysql --user=root mysql -p
you should get prompted for a password.
for the no databased selected error type use databasename; once you are connected, then attempt your insert.
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users