Art,
Monday, March 18, 2002, 5:51:46 PM, you wrote:
AF> I done the chown, now using MySQL Navigator, I get Access denied for user:
AF> afore@localhost (using passowrd: YES). I get the same for user mysql and
AF> root using both my password and root password.
Is your MySQL server running?
Looks like you have some difficulties with mysql privileges.
If you get 'access denied' error when you connect to the server,
it may seem that you are using a wrong password.
Causes of access denied errors are covered at:
http://www.mysql.com/doc/A/c/Access_denied.html
If you forgot password for the 'root' user you can reset it.
A tips how to reset password you can read in the manual:
http://www.mysql.com/doc/R/e/Resetting_permissions.html
AF> mysql is a group as shown in Yast2 login manager also. Permissions now shows
AF> drwxr-xr-x mysql mysql.
AF> -----Original Message-----
AF> From: Egor Egorov [mailto:[EMAIL PROTECTED]]
AF> Sent: Monday, March 18, 2002 4:04 AM
AF> To: [EMAIL PROTECTED]
AF> Subject: RE: mysql.sock
AF> Art,
AF> Monday, March 18, 2002, 3:50:19 AM, you wrote:
AF>> I get
AF>> drwxr-xr-x 4 mysql daemon 540 Mar 17 17:44 mysql
AF> MySQL datadir should belong to user 'mysql'.
AF> chown -R mysql.mysql /var/lib/mysql
AF>> Art
AF>> From: Dan Vande More [mailto:[EMAIL PROTECTED]]
AF>> That's because you get this:
AF>> '020317 16:48:10 mysqld ended.'
AF>> It means there was an error, and the database server is no longer
AF>> running.
AF>> Check your mysql log files to find out why.
AF>> Does the user, 'mysql' have permissions to write into the directory
AF>> mysql is
AF>> using, normally /var/lib/mysql
AF>> Who is the owner, and group for that directory? And what are the
AF>> permissions?
AF>> Do an 'ls -la /var/lib/'
AF>> You should have something like:
AF>> 'drwxrwxr-x 25 mysql root 3072 Mar 16 23:00 mysql'
AF>> or even
AF>> 'drwxrwxr-x 25 root mysql 3072 Mar 16 23:00 mysql'
--
For technical support contracts, goto https://order.mysql.com/
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Egor Egorov
/ /|_/ / // /\ \/ /_/ / /__ [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
