查看MySQL服务进程和端口
[root@snails mysql-5.7.13]# ps -ef | grep mysql root 23940 1 0 11:15 ? 00:00:00 /bin/sh /usr/local/mysql/bin/mysqld_safe --datadir=/data/mysql --pid-file=/data/mysql/mysql.pid mysql 24776 23940 0 11:15 ? 00:00:00 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/data/mysql --plugin-dir=/usr/local/mysql/lib/plugin --user=mysql --log-error=/data/mysql/mysql-error.log --open-files-limit=65535 --pid-file=/data/mysql/mysql.pid --socket=/dev/shm/mysql.sock --port=3306 [root@snails mysql-5.7.13]# netstat -tunpl | grep 3306 tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN 24776/mysqld
设置数据库root用户密码
MySQL和Oracle数据库一样，数据库也默认自带了一个 root 用户（这个和当前Linux主机上的root用户是完全不搭边的），我们在设置好MySQL数据库的安全配置后初始化root用户的密码。配制过程中，一路输入 y 就行了。这里只说明下MySQL5.7.13版本中，用户密码策略分成低级 LOW 、中等 MEDIUM 和超强 STRONG 三种，推荐使用中等 MEDIUM 级别！
[root@snails mysql-5.7.13]# mysql_secure_installation
常用操作
将MySQL数据库的动态链接库共享至系统链接库
一般MySQL数据库还会被类似于PHP等服务调用，所以我们需要将MySQL编译后的lib库文件添加至当前Linux主机链接库 /etc/ld.so.conf.d/下，这样MySQL服务就可以被其它服务调用了。
[root@snails mysql-5.7.13]# ldconfig |grep mysql [root@snails mysql-5.7.13]# echo "/usr/local/mysql/lib" > /etc/ld.so.conf.d/mysql.conf [root@snails mysql-5.7.13]# ldconfig [root@snails mysql-5.7.13]# ldconfig -v |grep mysql ldconfig: 无法对 /libx32 进行 stat 操作: 没有那个文件或目录 ldconfig: 多次给出路径“/usr/lib” ldconfig: 多次给出路径“/usr/lib64” ldconfig: 无法对 /usr/libx32 进行 stat 操作: 没有那个文件或目录 /usr/lib64/mysql: libmysqlclient.so.18 -> libmysqlclient.so.18.0.0 /usr/local/mysql/lib: libmysqlclient.so.20 -> libmysqlclient.so.20.3.0
创建其它MySQL数据库用户
[root@snails mysql-5.7.13]# mysql -uroot -p Enter password: Welcome to the MySQL monitor. Commands end with ; or g. Your MySQL connection id is 4 Server version: 5.7.13-log Source distribution Copyright (c) 2000, 2016, 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>
mysql>CREATE DATABASE `tonnydb` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; Query OK, 1 row affected (0.01 sec) mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | mysql | | performance_schema | | sys | | tonnydb | +--------------------+ 5 rows in set (0.00 sec) mysql> grant all privileges on tonnydb.* to 'tonny@%' identified by 'Hi.Tonny@888'; Query OK, 0 rows affected, 1 warning (0.00 sec) mysql> flush privileges; Query OK, 0 rows affected (0.01 sec) mysql> exit
