[BlueOnyx:04287] Re: MySQL/phpmyadmin error

[pm]

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