Symptoms
Attempts to manage customer’s MySQL databases produce errors:
Error: Connection to the database server has failed because of network problems: Try to establish connection failed
Resetting MySQL Admin Password in Plesk – Linux
Creating a MySQL Database in Plesk
Log into Plesk control panel on your dedicated or cloud server:
1. Click Websites & Domains
2. Click on Databases
Creating a MySQL Database in cPanel
Log into cPanel control panel on your dedicated server:
1. Click the MySQL Databases icon
2. In the box to the right of New Database, please provide a name for the database.
Creating a MySQL Database in Plesk
Log into Plesk control panel on your dedicated server:
1. Click Websites & Domains
2. Click on Databases
Creating a MySQL Dump File
Run the following command to dump a database:
# mysqldump database_name > Database_name.sql
For example, you want to dump a database called “mydb”.
# mysqldump mydb > mydb.sql
How to Reset a MySQL root Password
1. # /etc/init.d/mysqld stop
2. Start MySQL server without password:
# mysqld_safe –skip-grant-tables &
How to Setup a LAMP Server on CentOS 6
Setting the Maximum Connections on Your MySQL Server
Using your favorite text editor, as root, open up the /etc/my.cnf file (the location of the file may vary according to your distribution). You should see something like this:
# vi /etc/my.cnf
