I Need Help Initializing MySQL

[Anton Markov]

Stephen wrote:
> Anton Markov wrote:
> 
>> Ya, the documentation is not written with new users in mind. The entire
>> MySQL manual is more of a referrence guide than a manual.
>>
>> I could try to help, but I would rather do it on the mailing list so
>> others can learn from the solution.
>>
>> I am not sure if I completely understood your problem; I got that you
>> can't even connect to the MySQL server at all as root. I hope the above
>> steps help fix that, and if I misunderstoon the problem or you need
>> further assistance, just reply to the list and someone will try to help.
> 
> 
> Hi Anton
> 
> Thank you for your reply! Perhaps you could write a HOWTO for new users :)
> 
> I followed what suggested, and this is what resulted:
> 
> ========
> [root at pw bin]# killall mysqld
> [root at pw bin]# 050324 12:03:10  mysqld ended
> 
> [root at pw bin]# mysqld_safe --skip-grant-tables &
> [1] 5873
> [root at pw bin]# Starting mysqld daemon with databases from /var/lib/mysql
> 
> [root at pw bin]# mysql -u root
> Welcome to the MySQL monitor.  Commands end with ; or \g.
> Your MySQL connection id is 1 to server version: 4.0.20
> 
> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
> 
> mysql> GRANT ALL PRIVILEGES ON *.* TO root@'localhost' IDENTIFIED BY 'pw';
> ERROR 1047: Unknown command
> mysql>
> =======
> 
> The unknown command error has me very confused.
> 
> And suggestions?
> 
> Thanks!

That is the weirdest thing I have ever seen; I just tried the exact 
command and it works. I am not sure what to do at this point.

Try typing 'status' at the mysql> prompt, and see what it tells you.

Try running the command 'SELECT * FROM mysql.user;'

And tell us what the results are. This really is a most weird error.

Also, can you post your $HOME/my.cnf and /etc/my.cnf if they exist (edit 
out any sensitive info they may contain).

Try re-installing the mysql client and mysqld server (probably one RPM 
package if you installed from RPM.

-- 
Anton Markov <("anton" + "@" + "truxtar" + "." + "com")>

GnuPG Key fingerprint =
5546 A6E2 1FFB 9BB8 15C3  CE34 46B7 8D93 3AD1 44B4

*** LINUX - MAY THE SOURCE BE WITH YOU! ***
--
The Toronto Linux Users Group.      Meetings: http://tlug.ss.org
TLUG requests: Linux topics, No HTML, wrap text below 80 columns
How to UNSUBSCRIBE: http://tlug.ss.org/subscribe.shtml