Create a MySQL instance

1. Add the content to/etc/My. CNF.

[Mysqld_dev]
Socket =/tmp/MySQL. Sock
Port = 3307
PID-file =/var/run/mysqld/mysqld_dev.pid
Datadir =/var/lib/mysql_dev
Log =/var/log/mysqld_dev.log
Log-error =/var/log/mysqld_dev.err.log
User = MySQL

2. Create directories and files based on the above content

Mkdir/var/lib/mysqld_dev

Chown MYSQL: MySQL/var/lib/mysqld_dev

...

3. write/etc/rc. d/init. d/mysqld_dev, or from/etc/rc. d/init. d/mysqld copy, and modify the code for obtaining parameters.

Get_mysql_option mysqld_dev datadir "/var/lib/MySQL"
Datadir = "$ result"
Get_mysql_option mysqld_dev socket "$ datadir/MySQL. Sock"
Socketfile = "$ result"
Get_mysql_option mysqld_dev log-error "/var/log/mysqld. log"
Errlogfile = "$ result"
Get_mysql_option mysqld_dev pid-file "/var/run/mysqld. pid"
Mypidfile = "$ result"

 

4. Start server

Servie mysqld_dev start

Error detected

Mysqld_safe [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql. host' doesn' t exist

You must use mysql_install_db to create a system table.

Mysql_install_db -- user = mysql -- datadir =/var/lib/mysql_dev/

Restart again, successful

 

5. Use mysql-u root-S/tmp/mysql. sock to connect to this instance.

6. If you do not want to write-S/tmp/mysql_dev.sock, you can add the code in [client] Of my. cnf to set the default sock.

[Client]
Socket =/tmp/mysql_dev.sock
 

 

 

 

 

This article is created by happy writers