Re: Mysql

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


It won't accept my hostname. I get up to mysqladmin version, works ok.

Then mysqlshow fails. Mysqladmin -u root password new_password works,

mysqladmin -u root -h my_system_hostname password mysql_root_password fails, cannot access with that hostname.

I'm following the Suse Linux 10 Unleashed manual page 520 to 525. It makes me angry when I follow directions and they don't work.
I uninstall the whole dam thing and deleted everything again.



--
Blattus Slafaly ? 3 :) 7/8
.

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
    ... mysqlshow: Access denied for user 'root'@'localhost' ... 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 ...
    (alt.os.linux.suse)
  • [Full-Disclosure] Proofpoint Protection Server remote MySQL root user vulnerability
    ... The MySQL server may be remotely access by the "root" user without using ... The Proofpoint Protection Server is a software product to filter spam ... the embedded MySQL 4.0 server binds to the default port ... Remote root will not be able to FLUSH ...
    (Full-Disclosure)
  • Re: myqsl dummy needs help
    ... Mike Wright wrote: ... MySQL does this. ... user that user is totally separate from the OS root account. ... I don't install MySql very often but I seem to recall an alert given ...
    (Fedora)