I Need Help Initializing MySQL

[Devin Whalen]

Sorry, I re-read you email and saw that your version number is the same
as mine.  Sorry, should have read more carefully :(.

On Thu, 2005-03-24 at 12:11 -0500, 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!
-- 
Devin Whalen
Programmer
Synaptic Vision Inc
Phone-(416) 539-0801
Fax- (416) 539-8280
1179A King St. West
Toronto, Ontario
Suite 309 M6K 3C5
Home-(416) 653-3982


Take back the Web with FireFox....a browser you can trust
www.getfirefox.com

   .-.
   /v\    L   I   N   U   X
  // \\  
 /(   )\
  ^^-^^   

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