Re: Mysql

Blattus Slafaly 0/00 ? ? ? wrote:

David Bolt wrote:
On Sun, 30 Mar 2008, Blattus Slafaly 0/00 ? ? ? wrote:-

<snip>

Why do I get this with mysqlshow?

No idea. I don't use it.

mysqlshow: Access denied for user 'username'@'localhost' (using
password: NO)

Did you "create" a user with access to the database without a password?

and as root:
mysqlshow: Access denied for user 'root'@'localhost' (using password:
YES)

Either the root user doesn't have a password configured, or you've
entered the wrong one. Try using a console and use mysql:

mysql -h localhost -u root

This will try to log you in without a password. If it fails, try:

mysql -h localhost -u root -p

You'll be asked to enter the password for root[0].

why can't I access my own system?

Because you aren't entering the correct details. Try the above, and see


[0] IIRC, when you start up the mysql daemon for the first time, it asks
you to set a password for user root at localhost and also for

It did not ask me anything when I started msyld.

Then you have not set up any users/passwords. Follow the advice given in
this thread and do so now. David's suggestions would be a good start.

Repeat. You have NOT set any users/passwords. Do so now. Then use one of
the gui to administer your database(s).
root@xxxxxxxxxxxxxx using /usr/bin/mysqladmin. If you haven't done very
much you might be lucky and find that command, including the password
you set, in your bash history.

Regards,
David Bolt




.

Quantcast