Tag: mysql

MySQL is not starting/working on Debian 6 + DirectAdmin

I just delivered a brand new server with Debian Squeeze + DirectAdmin, I have got no errors while installing DirectAdmin, but after the installation I noticed that mysql was not running. After some debugging I found the following error: 110530 22:59:40 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data /usr/local/mysql/bin/mysqld: error while loading shared libraries: […]

Cannot create database with DirectAdmin

I see a lot of DirectAdmin users who cannot create a mysql database. When you see the following error, I am sure I can help you out: Error connecting to MySQL: Access denied for user ‘da_admin’@’localhost’ (using password: YES) First make sure your mysql root password is working, you can test it out using the […]

How to reset the MySQL root password

If you have forgotten the mysql root passwod, you can set a new password if you have root access to the server. 1. Stop MySQL server. # /etc/init.d/mysql stop 2. Start MySQL with –skip-grant-tables option. # mysqld_safe –skip-grant-tables & 3. Connect to MySQL as root. # mysql -u root 4. Set new mysql root password. […]