[BlueOnyx:04288] Re: MySQL/phpmyadmin error

[Don Teague]

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
>