with databases from /usr/local/mysql/data
9. 设置MySQL root权限的密码；
vonzhou@de16-C6100:/usr/local/mysql$ sudo bin/mysqladmin -u root password '你的密码'
Warning: Using a password on the command line interface can be insecure.
10. 把执行脚本移到init.d目录下；
vonzhou@de16-C6100:/usr/local/mysql$ sudo cp support-files/mysql.server /etc/init.d/mysql.server
11.此时可以查看运行状态，可以用service命令的status/start/stop/restart控制；
vonzhou@de16-C6100:/usr/local/mysql$ sudo service mysql.server status
* MySQL running (5477)
12.设置开机启动（就是插入到那些开机会自动运行的脚本中），取消自启动的话defaults -> remove ;
vonzhou@de16-C6100:/usr/local/mysql$ sudo update-rc.d mysql.server defaults
Adding system startup for /etc/init.d/mysql.server ...
/etc/rc0.d/K20mysql.server -> ../init.d/mysql.server
/etc/rc1.d/K20mysql.server -> ../init.d/mysql.server
/etc/rc6.d/K20mysql.server -> ../init.d/mysql.server
/etc/rc2.d/S20mysql.server -> ../init.d/mysql.server
/etc/rc3.d/S20mysql.server -> ../init.d/mysql.server
/etc/rc4.d/S20mysql.server -> ../init.d/mysql.server
/etc/rc5.d/S20mysql.server -> ../init.d/mysql.server
13.搞个符号连接，方便命令的输入；
vonzhou@de16-C6100:/usr/local/mysql$ sudo ln -s /usr/local/mysql/bin/mysql /usr/local/bin/mysql
14. 此时，就按照好了，可以简单测试下。 vonzhou@de16-C6100:/usr/local/mysql$ mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.6.23 MySQL Community Server (GPL)
Copyright (c) 2000, 2015,
Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| test |
+--------------------+
2 rows in set (0.00 sec)
mysql> exit
Bye
|