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

[pm]

Hi all
In ref to Don's problem, it might be worth while looking at why this 
happened.  Don wasn't too sure.  This I understand as it can happen without 
the user being aware of it,  until the no connection appears in the GUI.

I can explain in one case at least.

If your a cmcms user and its installed in the GUI, be careful.
If you put in root user and root password into the site settings and tick 
the box to install, all goes well and site is installed with cmsms.

If at some point later, or your just testing, you untick the box, to 
uninstall the cmsms.,  root user is deleted. No warning of this or anything 
else. Not until you go back sometime and notice the no connection error 
message, or you notice phpmyadmin doesn't work.

Other examples would be useful to know.

A safeguard against this would be to set up another user with full root 
rights in mysql. to use when needed.

regards
Peter




----- Original Message ----- 
From: "Don Teague" <blueonyx at donteague.com>
To: "BlueOnyx General Mailing List" <blueonyx at blueonyx.it>
Sent: Monday, April 19, 2010 1:07 AM
Subject: [BlueOnyx:04301] Re: Fw: Re: MySQL/phpmyadmin error


> 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
>>
>
> _______________________________________________
> Blueonyx mailing list
> Blueonyx at blueonyx.it
> http://www.blueonyx.it/mailman/listinfo/blueonyx