mysql not run in dsm

[pmm]

mysql not run in dsm need help.any idea.I have reviewed to where wise

[pmm]

Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

[pmm]

ps auwx | grep mysqld
root 1056 0.0 0.0 4424 1052 pts/0 T 22:01 0:00 /bin/sh /usr/bin/safe_mysqld
mysql 1088 0.0 0.0 0 0 pts/0 Z 22:01 0:00 [mysqld <defunct>]
root 1226 0.0 0.0 4432 1056 pts/0 T 22:02 0:00 /bin/sh /usr/bin/safe_mysqld
mysql 1247 0.0 0.0 0 0 pts/0 Z 22:02 0:00 [mysqld <defunct>]
root 1285 0.0 0.0 4432 1056 pts/0 T 22:04 0:00 /bin/sh /usr/bin/safe_mysqld
mysql 1306 0.0 0.1 14136 2196 pts/0 S 22:04 0:00 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-locking
mysql 1307 0.0 0.1 14136 2196 pts/0 S 22:04 0:00 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-locking
mysql 1308 0.0 0.1 14136 2196 pts/0 S 22:04 0:00 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-locking
root 1599 0.0 0.0 3920 668 pts/0 S 22:16 0:00 grep mysqld

[pmm]

mysql -u root -p
Enter password:**********
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 4 to server version: 3.23.58

[LeeJ]

you copied the old mysql files onto the new server without changing the dsm mysql password on the new machine. That is why dsm could not connect.

Resovlved per ticket.

[pmm]

we did not wish to bother but dsm follows equal
MySQL Manager
MySQL Is Not Running, Please use the Service Manager to restart it.
-------------------------------------------------------
mysql> status
--------------
mysql Ver 11.18 Distrib 3.23.58, for redhat-linux-gnu (i386)

Connection id: 3
Current database: mysql
Current user: root@localhost
Current pager: stdout
Using outfile: ''
Server version: 3.23.58
Protocol version: 10
Connection: Localhost via UNIX socket
Client characterset: latin1
Server characterset: latin1
UNIX socket: /var/lib/mysql/mysql.sock
Uptime: 27 min 23 sec

Threads: 1 Questions: 80 Slow queries: 0 Opens: 61 Flush tables: 1 Open tables: 55 Queries per second avg: 0.049
--------------
we do not understand because this working mysql and dsm says stop to us.
beforehand thanks for its collaboration.

[pmm]

mysql> mysql> status
-> --------------
-> mysql Ver 11.18 Distrib 3.23.58, for redhat-linux-gnu (i386)
->
-> Connection id: 13
-> Current database:
-> Current user: dsm@localhost
-> Current pager: stdout
-> Using outfile: ''
-> Server version: 3.23.58
-> Protocol version: 10
-> Connection: Localhost via UNIX socket
-> Client characterset: latin1
-> Server characterset: latin1
-> UNIX socket: /var/lib/mysql/mysql.sock
-> Uptime: 47 min 5 sec
->
-> Threads: 3 Questions: 81 Slow queries: 0 Opens: 61 Flush tables: 1 Open tables: 55 Queries per second avg: 0.02

[pmm]

mysql> mysql> status
-> --------------
-> mysql Ver 11.18 Distrib 3.23.58, for redhat-linux-gnu (i386)
->
-> Connection id: 13
-> Current database:
-> Current user: dsm@localhost
-> Current pager: stdout
-> Using outfile: ''
-> Server version: 3.23.58
-> Protocol version: 10
-> Connection: Localhost via UNIX socket
-> Client characterset: latin1
-> Server characterset: latin1
-> UNIX socket: /var/lib/mysql/mysql.sock
-> Uptime: 47 min 5 sec
->
-> Threads: 3 Questions: 81 Slow queries: 0 Opens: 61 Flush tables: 1 Open tables: 55 Queries per second avg: 0.02

[LeeJ]

DSM was looking for your mysql.sock file within the temp directory.

Resolved....

[pmm]

thanks for support.he was desperate