mysql Access denied for user 'root'@'localhost'

Why are you thinking that there would not be a mysql root password? I have never seen a mysql server without a set password in my life.
That is just extremely insecure.

You need to use the login credentials in /usr/local/directadmin/conf/mysql.conf
 
Server load goes up every day because of a problem in the database

For example,
1849 mysql 20 0 2840m 770m 2444 S 1.5 41.1 0:22.61 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/lib/mysql/s5.henterz.com.err --pid-file=/var/lib/mysql/s5.henterz.com.pid --socket=/var/lib/mysql/mysql.sock --port=3306

How can I solve this problem?
 
Hello,

Live watch and/or save snapshots with cron every 5-10 minutes:

Code: 
/usr/bin/mysqladmin --defaults-extra-file=/usr/local/directadmin/conf/my.cnf processlist --verbose

and/or enable slow logs logging in MySQL. As soon as you figure out what is wrong you may fix it.
 
You must log in or register to reply here.
Back
Top