Often on virtual servers there is a problem with the database load or the slow operation of the database, so we will give an example of optimizing the MySQL settings. The database configuration file is located at: /etc/my.cnf /etc/mysql/my.cnf Remember that the parameters are configured

This note may be useful for those who are just starting to use the MySQL. Everything happens for the first time. For example, you got a job, or wanted to work in a project where this system was used. Reading manuals is of course helpful. But the return on reading

Connect to the MySQL server from the command line as root: mysql -u root -p Create MySQL Database Use the following syntax to create a database in MySQL: CREATE DATABASE name_base; Create a new user: GRANT ALL PRIVILEGES ON name_base.* TO name_user@localhost IDENTIFIED BY 'PASSWORD&