MySQL8.0.13封包备忘录

1. 空机器要打依赖包
   sudo zypper install libncurses5

2. 启动MySQL
   dev@linux-wqwc:~/lotusVM/bin> mysql start
   ./mysql : mysql  started at port 3307

3. 查看状态
   dev@linux-wqwc:~> mysql status
   mysql already running

4. 登录控制台
   dev@linux-wqwc:~/lotusVM/db/mysql/bin> ./mysql -uroot -p123456 mysql
   mysql.bin: [Warning] Using a password on the command line interface can be insecure.
   Reading table information for completion of table and column names
   You can turn off this feature to get a quicker startup with -A

   Welcome to the MySQL monitor.  Commands end with ; or \g.
   Your MySQL connection id is 9
   Server version: 8.0.13 MySQL Community Server - GPL

   Copyright (c) 2000, 2018, 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;

5. 关闭MySQL
   dev@linux-wqwc:~> mysql stop
   /home/dev/lotusVM/bin/mysql : mysql stopped

6. 运维脚本

转载于:https://my.oschina.net/891130/blog/3002008