Tom,
Thursday, April 25, 2002, 5:40:11 PM, you wrote:
TM> I am having the same problem and cannot find any document which can get
TM> me beyond Access denied...
TM> Could you explain the difference between Linux 'root' user and 'root'
TM> user in MySQL?
MySQL user 'root' is usual user, it's a user with name 'root'. :) By default 'root'
user in MySQL has all privileges, but you can change it. When you connect to the MySQL
server, run MySQL utilities you can use option '--user=<user_name>'.
MySQL uses <user_name> to indentified user (password and host also
are used for identification). If you don't specify user name, it means
that you connected as anonymous user. Anonymous users are defined by
inserting entries with User='' into the mysql.user table or creating
an user with an empty name with the GRANT command.
'root' user in Linux is a "superuser" of OS, not of MySQL.
Look at the MySQL documentation, there are a LOT a of info about
privilege system in MySQL:
http://www.mysql.com/doc/P/r/Privilege_system.html
http://www.mysql.com/doc/U/s/User_Account_Management.html
TM> Subject: Re: ERROR 1045: Access denied for user: 'root@localhost'
TM> From: Victoria Reznichenko
TM> Date: Tue, 23 Apr 2002 16:38:01 +0300
>>> [root@omsrh etc]# mysql
>>> ERROR 1045: Access denied for user: 'root@localhost' (Using password:
TM> NO)
TM> It means that anonymous user doesn't have any privileges ...
TM> Unix 'root' user and 'root' user in MySQL are different ...
--
For technical support contracts, goto https://order.mysql.com/
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Victoria Reznichenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
