LinuxQuestions.org
Help answer threads with 0 replies.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 01-03-2004, 10:31 PM   #1
sigep739
LQ Newbie
 
Registered: Dec 2003
Posts: 16

Rep: Reputation: 0
Updating MySQL grant tables...


Hi-

I am trying to update the grant tables in MySQL.. so I go ahead and log into MySQL as root... I then run a 'shell' command from the MySQL server-

mysql> \! mysql_fix_privilege_tables

It does not work... I get (below) that I need to run the script again giving the root user password as an argument... How do I do that??





mysql> \! mysql_fix_privilege_tables

This scripts updates the mysql.user, mysql.db, mysql.host and the

mysql.func tables to MySQL 3.22.14 and above.



This is needed if you want to use the new GRANT functions,

CREATE AGGREGATE FUNCTION or want to use the more secure passwords in 3.2



If you get 'Access denied' errors, you should run this script again

and give the MySQL root user password as an argument!

Converting all privilege tables to MyISAM format

ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)



If your tables are already up to date or partially up to date you will

get some warnings about 'Duplicated column name'. You can safely ignore t

ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)



Creating Grant Alter and Index privileges if they don't exists

You can ignore any Duplicate column errors

ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)



Adding columns needed by GRANT .. REQUIRE (openssl)

You can ignore any Duplicate column errors

ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)



Creating the new table and column privilege tables

ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)

Changing name of columns_priv.Type -> columns_priv.Column_priv

You can ignore any Unknown column errors from this

ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)



Fixing the func table

You can ignore any Duplicate column errors

ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)



Adding new fields used by MySQL 4.0.2 to the privilege tables

You can ignore any Duplicate column errors

ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)

ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)

ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)
 
Old 01-03-2004, 11:12 PM   #2
Wolven
Member
 
Registered: Jan 2003
Posts: 195

Rep: Reputation: 30
As root, but NOT in the mysql client, and just saying your password is the word "secret", run this:



mysql_fix_privilege_tables secret
 
Old 01-04-2004, 12:57 AM   #3
sigep739
LQ Newbie
 
Registered: Dec 2003
Posts: 16

Original Poster
Rep: Reputation: 0
Thank you!
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Grant Privileges - MySQL Jannyno Linux - General 2 06-23-2012 03:00 AM
Why mysql GRANT does not work? robertoneto123 Linux - Software 2 01-23-2004 08:33 AM
mysql grant issues Robin01 Linux - Newbie 1 10-29-2003 10:56 PM
MYSQL GRANT etc etc markopolox Programming 8 09-23-2003 03:58 AM
Mysql User grant problems ubers0ldat Linux - Software 7 07-30-2003 01:33 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie

All times are GMT -5. The time now is 09:34 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration