Re: Mysql

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
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

--
www.davjam.org/lifetype/ www.distributed.net: OGR@100Mnodes, RC5-72@15Mkeys
SUSE 10.1 32bit | openSUSE 10.2 32bit | openSUSE 10.3 32bit | openSUSE 11.0a1
SUSE 10.1 64bit | openSUSE 10.2 64bit | openSUSE 10.3 64bit
RISC OS 3.6 | TOS 4.02 | openSUSE 10.3 PPC |RISC OS 3.11
.

Relevant Pages

  • Re: Mysql
    ... mysqlshow: Access denied for user 'root'@'localhost' (using password: ... Either the root user doesn't have a password configured, ... Try using a console and use mysql: ... mysql -h localhost -u root -p ...
    (alt.os.linux.suse)
  • Re: Mysql
    ... David Bolt wrote: ... Try using a console and use mysql: ... mysql -h localhost -u root -p ... Then mysqlshow fails. ...
    (alt.os.linux.suse)
  • Re: mysql connect problems
    ... don't think you'll have an empty root password;) ... When I log into mysql as root, ... > mysql database, and run 'select user, password, host from user;' I ... Well, I have checked it as well, and I have just the root user on localhost ...
    (freebsd-questions)
  • Re: myqsl dummy needs help
    ... 609 of MySQL, Third Edition, by Paul DuBois and read through the next ... There is no localhost in my /etc/passwd file, do I need to adduser first? ... You need to set both these passwords for root. ... user that user is totally separate from the OS root account. ...
    (Fedora)
  • Re: Mysql
    ... David Bolt wrote: ... Try using a console and use mysql: ... mysql -h localhost -u root -p ...
    (alt.os.linux.suse)