[BlueOnyx:04290] Re: MySQL/phpmyadmin error

[pm]

Save this in 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';
flush privileges;

Then run
sudo /etc/init.d/mysql stop
sudo mysqld --skip-grant-tables &
mysql < restore_root_privileges.sql

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









----- Original Message ----- 
From: "Don Teague" <blueonyx at donteague.com>
To: "BlueOnyx General Mailing List" <blueonyx at blueonyx.it>
Sent: Sunday, April 18, 2010 3:35 PM
Subject: [BlueOnyx:04288] Re: MySQL/phpmyadmin error


>I forgot to reply to the first person who suggested this ...
>
> but restore_root_privileges.sql is not found anywhere on my machine ...
>
> On Sun, Apr 18, 2010 at 9:23 AM, pm <pm at nm.tm> wrote:
>> sudo /etc/init.d/mysql stop
>> sudo mysqld --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;
>>
>>
>> ----- Original Message -----
>> From: "Don Teague" <blueonyx at donteague.com>
>> To: "BlueOnyx General Mailing List" <blueonyx at blueonyx.it>
>> Sent: Sunday, April 18, 2010 5:01 AM
>> Subject: [BlueOnyx:04281] Re: MySQL/phpmyadmin error
>>
>>
>>> File not found.
>>>
>>> Still no GUI access to root/pass for mysql, or phpmyadmin access (as
>>> none of the DB's are listed.)
>>>
>>> They are on the system, because the sites are up.
>>>
>>> Oh well....
>>>
>>> On Sat, Apr 17, 2010 at 10:50 PM, Jimmy Gross <grossj at constantino.net>
>>> wrote:
>>>> Try to access phpMyAdmin at:
>>>>
>>>> http://ServerIP/phpMyAdmin/
>>>>
>>>> jimmy
>>>>
>>>> -----Original Message-----
>>>> From: blueonyx-bounces at blueonyx.it
>>>> [mailto:blueonyx-bounces at blueonyx.it]On Behalf Of Don Teague
>>>> Sent: Saturday, April 17, 2010 10:41 PM
>>>> To: BlueOnyx General Mailing List
>>>> Subject: [BlueOnyx:04279] Re: MySQL/phpmyadmin error
>>>>
>>>>
>>>> So, if the mysql.mysqldump.sql dump file contains only the 'mysql'
>>>> database ... does anyone think this would solve my problem?
>>>>
>>>> mysql -u root -ppasswordofmysql < mysql.mysqldump.sql
>>>>
>>>> A "show databases;" command when I'm logged into mysql does not show
>>>> this database...
>>>>
>>>>
>>>> On Sat, Apr 17, 2010 at 9:28 PM, Don Teague <blueonyx at donteague.com>
>>>> wrote:
>>>>> On MySQL start ...
>>>>>
>>>>> [Sat Apr 17 21:23:44 2010] [error] [client xx.xx.xx.xx] PHP Warning:
>>>>> mysql_connect() [<a
>>>>> href='function.mysql-connect'>function.mysql-connect</a>]: Can't
>>>>> connect to local MySQL server through socket
>>>>> '/var/lib/mysql/mysql.sock' (2) in
>>>>> /usr/sausalito/ui/web/base/mysql/mysql.php on line 102, referer:
>>>>> https://yy.yy.yy.yy81/base/mysql/redirector.php
>>>>>
>>>>> Line 102 of /usr/sausalito/ui/web/base/mysql/mysql.php
>>>>> $mysql_link = mysql_connect($con_sql_host, $sql_root,
>>>>> $sql_rootpassword) or $mysql_error = mysql_error();
>>>>>
>>>>>
>>>>> On Sat, Apr 17, 2010 at 9:17 PM, Gerald Waugh <gwaugh at raqware.com>
>>>>> wrote:
>>>>>>
>>>>>> On Sat, 2010-04-17 at 20:58 -0500, Don Teague wrote:
>>>>>>> Have. Many times.
>>>>>>>
>>>>>>> Still no GUI access.
>>>>>> Have you looked at the log files
>>>>>> /var/log/admserv/adm_error
>>>>>> see if any errors are thrown
>>>>>> maybe
>>>>>> /var/log/mysqld.log
>>>>>>
>>>>>>
>>>>>> _______________________________________________
>>>>>> 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
>>>>
>>>> _______________________________________________
>>>> 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
>>
>> _______________________________________________
>> 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