MySQL Start - Stop problem

xtian · Post by **xtian** » Wed Sep 12, 2007 12:39 am

Hello!

I have a TS-109 with firmware 1.1.1 Build 0911T (same problem with 1.1.1 Build 0831T).

When I try to disable MySQL I get the following error in the Event log:

Error [MySQL Server] stopped failed.

I also can't login using phpMyAdmin. I do not use any application that use MySQL yet so I don't know if the MySQL-server is started.

I was able to start and stop MySQL and login using phpMyAdmin before upgrading firmware to 1.1.1 Build 0831T.

I've tried to restart TS-109 and also tried to reset root password for MySQL.

Any suggestions?

Post by **kent** » Wed Sep 12, 2007 10:32 am

If you can use ssh/telnet login, please help to check belows
1. run command "/etc/init.d/mysqld.sh restart"
2. run command "ps", check if process "mysqld" & "mysqld_safe" are alive
Pleae let me know the results, thanks.

xtian · Post by **xtian** » Thu Sep 13, 2007 12:20 am

Here are the results:

1. run command "/etc/init.d/mysqld.sh restart"

Shutting down MySQL.. SUCCESS!
Starting MySQL. SUCCESS!

2. run command "ps", check if process "mysqld" & "mysqld_safe" are alive

9800 admin 1048 S /bin/sh /usr/local/mysql/bin/mysql_safe --datadir=/u
9834 admin 14504 S /usr/local/mysql/libexec/mysqld --basedir=/usr/local/

Still can't login in phpMyAdmin, error:

#1045 - Access denied for user 'root'@'localhost' (using password: YES)

Tried to reset root password from web-interface.

If I uncheck the checkbox for "Enable MySQL Server" and press the button "Apply" the page reload but the checkbox are still checked. This is the error in eventlog:

Error [MySQL Server] stopped failed.

Post by **kent** » Thu Sep 13, 2007 10:01 am

It seems MySQL can normally launch success in your TS server.
I think maybe the database file was broken.
My suggestion is:
Go to web administration, in "Network setting"->"MySQL Server" page
click checkbox "Database maintenance", then execute "reset root password" and "Re-initialize database"

Please let me know the final result, thanks.

xtian · Post by **xtian** » Thu Sep 13, 2007 1:56 pm

OK, tried that.

Still can't login in phpMyAdmin with root - admin, error:

#1045 - Access denied for user 'root'@'localhost' (using password: YES)

Still can't disable MySQL server, error in eventlog:

Error [MySQL Server] stopped failed.

Post by **kent** » Thu Sep 13, 2007 2:53 pm

Can you PM me your IP and admin's password for checking?

xtian · Post by **xtian** » Fri Sep 14, 2007 2:15 pm

Ok, send you a PM.