Cannot log into fresh install of MySQL. Please advise.
 

Hello,

I just installed mySQL 4 and cannot log in.

The instructions at http://dev.mysql.com/doc/mysql/en/Access_denied.html did not help because they do not list the error which is

ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)

The very forst thing the instructions say to do is log in and put passwprds on the root user but I cannot log in. The instructions say to

mysql -u root

but this just results in the error message above. Please help.

I would install the MySQL Control Center on either the server or preferably a machine networked to it and try it that way. That could tell you whether or not it is a host problem or a user name issue.

Try to find the 0.89beta if you can, the latest Control Center only shows me the first 1000 rows for any query I throw at it, whereas the 0.89beta worked perfectly.

Give this a shot........

http://dev.mysql.com/doc/mysql/en/Re...rmissions.html


Im not a pro, but I can still find stuff on the net! =P

Sky

You need to specify the -p option:


mysql -u root -p