[BlueOnyx:04301] Re: Fw: Re: MySQL/phpmyadmin error

[Don Teague]

cat > restore_root_privileges.sql

update mysql.user set Super_priv='y' where user='root';
update mysql.user set Select_priv='y' where user='root';
update mysql.user set Insert_priv='y' where user='root';
update mysql.user set Update_priv='y' where user='root';
update mysql.user set Delete_priv='y' where user='root';
update mysql.user set Create_priv='y' where user='root';
update mysql.user set Drop_priv='y' where user='root';
update mysql.user set Reload_priv='y' where user='root';
update mysql.user set Shutdown_priv='y' where user='root';
update mysql.user set Process_priv='y' where user='root';
update mysql.user set File_priv='y' where user='root';
update mysql.user set Grant_priv='y' where user='root';
update mysql.user set References_priv='y' where user='root';
update mysql.user set Index_priv='y' where user='root';
update mysql.user set Alter_priv='y' where user='root';
update mysql.user set Show_db_priv='y' where user='root';
update mysql.user set Super_priv='y' where user='root';
update mysql.user set Create_tmp_table_priv='y' where user='root';
update mysql.user set Lock_tables_priv='y' where user='root';
update mysql.user set Execute_priv='y' where user='root';
update mysql.user set Repl_slave_priv='y' where user='root';
update mysql.user set Repl_client_priv='y' where user='root';
update mysql.user set Create_view_priv='y' where user='root';
update mysql.user set Show_view_priv='y' where user='root';
update mysql.user set Create_routine_priv='y' where user='root';
update mysql.user set Alter_routine_priv='y' where user='root';
update mysql.user set Create_user_priv='y' where user='root';

------------------------------------------------------------------

/etc/rc.d/init.d/mysqld stop
/etc/rc.d/init.d/mysqld --skip-grant-tables &

sudo /etc/init.d/mysql stop
sudo mysqld_safe --skip-grant-tables &
mysql -vv < restore_root_privileges.sql

sudo /etc/init.d/mysql restart
mysql -u root -p
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION;
mysql> quit;

On Sun, Apr 18, 2010 at 6:17 PM, Darrell D. Mobley <dmobley at uhostme.com> wrote:
>> -----Original Message-----
>> From: blueonyx-bounces at blueonyx.it [mailto:blueonyx-bounces at blueonyx.it]
>> On Behalf Of Trond Husø
>> Sent: Sunday, April 18, 2010 3:14 PM
>> To: BlueOnyx General Mailing List
>> Subject: [BlueOnyx:04299] Re: Fw: Re: MySQL/phpmyadmin error
>>
>> Hi Don,
>>
>> Glad to hear that things have worked out for you. Could you please post
>> to the list what the solution was? :)
>>
>> trond
>> On Sun, 2010-04-18 at 13:56 -0500, Don Teague wrote:
>> > This issue appears to be resolved.
>> >
>> > Thanks to the person who emailed me off-list to work with me on this.
>
> Yes, please. If someone else encounters this, it might help them.
>
>
> _______________________________________________
> Blueonyx mailing list
> Blueonyx at blueonyx.it
> http://www.blueonyx.it/mailman/listinfo/blueonyx
>