MySQL Installation and configuration

MySQL Installation:

1. 1. at command-line input sudo apt- get install Mysql- server  
   2. A window will pop up during installation, enter the password for the database root user ( must enter password )      
   3. after installation through mysql - uroot - p and enter the password you entered earlier to enter the MySQL Data Environment     

To configure the encoding for MySQL:

1. 2. MySQL database encoding is latin1
   4. View database encoding: Show variables like '%char%'
   6. Ubuntu_server MYSQL Modified encoded file:/ETC/MYSQL/CONF.D/MYSQL.CNF
   7. Use the Vim editor to edit this file (mysql.cnf): (Paste the following code directly)
      

      [client] default - character - Set = UTF8 [mysqld] character - Set - = utf8collation - = Utf8_general_ci

   9. Restart server (must restart): service MySQL Restart　　　　　　

To create a MySQL user:

2. To create a user:

   Create User ' username '@ '%' by'password';

4. Empowerment:

   Grant  All  on *. *  to ' username '@'%';

6. Refresh: flush privileges;

Graphical operation of MySQL:

h eidisql is a free graphical software that operates on MySQL. : Https://www.heidisql.com/download.php?download=installer

1. Remote connection MySQL or using a graphical tool connection you must modify MySQL The port inside the configuration file
2. Files that are located Ubuntu-server MySQL under the Modify port /etc/mysql/mysql.conf.d mysqld.cnf
3. Find bind-address this line, then 127.0.0.1 change it and 0.0.0.0 save it and exit.
4. Then restart the service
5. Create a MySQL normal user that can connect using a normal user. Remember to refresh

You can connect to the database remotely by completing the above necessary actions.

　　　　

　　

MySQL Installation and configuration