FC2/mySQL (OT?)

Alexander Dalloz alexander.dalloz at uni-bielefeld.de
Sat Jul 17 20:42:59 UTC 2004

Am Sa, den 17.07.2004 schrieb John Dangler um 22:19:

> when running mysql from a command line (FC2), I cannot connect as
> 'root at localhost'.
> However, phpMyAdmin connects with the same user/password and is fine.
> I also have a test user who can only connect to the 'test' database, and
> that works fine, as well.
> If I check the grants, etc on the root user, everything is granted to that
> user.
> The other user installed (localhost) has no privileges, but I thought that
> user was the registering of the host.
> Can anyone point me in a direction to get this resolved?

> John Dangler

Your description is a bit confuse and lacks important information.

You did set a password for the MySQL root user? Important: the MySQL
root user is not the same as the system root, means they can have
different passwords set.

How do you use the mysql command line? What exactly do you type in and
what is the error message you get?

Did you read the MySQL documentation on the www.mysql.com site? It
contains very good help and explanations about such basic things.


Alexander Dalloz | Enger, Germany | GPG key 1024D/ED695653 1999-07-13
Fedora GNU/Linux Core 2 (Tettnang) Athlon CPU kernel 2.6.6-1.435.2.3.uml
Serendipity 22:38:53 up 4 days, 20:21, load average: 0.37, 0.41, 0.43 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: Dies ist ein digital signierter Nachrichtenteil
Url : http://lists.fedoraproject.org/pipermail/users/attachments/20040717/8dfd011e/attachment-0002.bin 

More information about the users mailing list