The MySQL ® software provides a database server SQL (Structured Query Language) very fast, multi-threaded, multi-user and robust. The MySQL server is designed for mission critical production environments with high workload and to integrate software to be distributed. It is ideal for dynamic web sites.
Please also read the official documentation in English MySQL (online). You can also download
to be accessed without an Internet connection.
The aim of this paper is to present basic information which is essential to know about MySQL so that the service safer. main configuration file of MySQL is "/ etc / mysql / my.cnf.
By default the logs are not activated, so it is advisable to activate, this is done by uncommenting the line "log = / var / log / mysql / mysql.log" from "/ etc / mysql / my.cnf"
For default, only allows connections to MySQL Service locally. To allow remote connections is to modify the directive "bind-address" file "/ etc / mysql / my.cnf" indicating that IP listening on the desired network interface so that it is as follows:
bind-address = 192.168.0.1
Replace "192.168.0.1" for the IP of your server.
By default, the root user (administrator) of MySQL not assigned any password. To assign a password to do run the following command: $ mysqladmin-u root password
su_password
Another way is directly from the mysql client:
0 comments:
Post a Comment