Could someone tell me why I cannot connect to mysql as
root.  I just installed the rpm for 3.23.32.  I have root
access to my machine.  How do I get root access to mysql? 
What am I missing in the directions?  I have read them over
many times.

Here is what I have done:

rpm took care of these steps:

shell> groupadd mysql
shell> useradd -g mysql mysql
shell> cd /usr/local
shell> gunzip < /path/to/mysql-VERSION-OS.tar.gz | tar xvf -

I did these steps:

shell> mkdir /usr/local/mysql
shell> mysql_install_db
shell> chown -R mysql /usr/local/mysql
shell> chgrp -R mysql /usr/local/mysql


shell> bin/safe_mysqld --user=mysql &           # the daemon dies if
I run this
# this step fails, I can only run "safe_mysqld &"

# after starting safe_mysqld I try this:
> mysql -u root
# this fails whether I run as mysql or root
# I get this error "ERROR 1045: Access denied for user:
'root@localhost' (Using password: NO)"

--
Jeff Greer
- B.S. computer science - Univ. MO - Rolla
- web developer/software engineer,
dedicated to the struggle against the fascist
Microsoft hegemony

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

Reply via email to