I Need Help Initializing MySQL

Anton Markov anton-F0u+EriZ6ihBDgjK7y7TUQ at public.gmane.org
Thu Mar 24 19:09:08 UTC 2005


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

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?

Well, it appears I got it all wrong :(

You can't use the GRANT command without the privilege tables.

Either try the command "FLUSH PRIVILEGES" and then right after do the
GRANT command as described above, or if that doesn't work, go to the
following page and search for a comment by "Rusty Carruth" which
provides a step-by-step guide:

<http://sunsite.mff.cuni.cz/MIRRORS/ftp.mysql.com/doc/en/Timezone_problems.html>

- --
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! ***
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.0 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFCQxBTRreNkzrRRLQRAhy7AJ9q3r5pTsbdebYoSucfqeohJ3r7fQCfUo9w
rVk/xTsTmjjwE5xoApotnJo=
=Nhvm
-----END PGP SIGNATURE-----
--
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





More information about the Legacy mailing list