MySQL基础部分

mysql安装脚本

安装前请将相关安装包copy放到/server/tools目录下

-rw-r--r-- 1 root root 314149697 Mar 23  2017 mysql-5.6.34-linux-glibc2.5-x86_64.tar.gz

执行安装脚本：

 #!/bin/bash

 #install MySQL

 #新增用户

 useradd -M -s /sbin/nologin mysql

 #进入软件目录

 cd /server/tools

 #解压

 tar xf mysql-5.6.34-linux-glibc2.5-x86_64.tar.gz

 #移动目录并创建软连接

 mv mysql-5.6.34-linux-glibc2.5-x86_64 /application/mysql-5.6.34

 ln -s /application/mysql-5.6.34/ /application/mysql

 #授权

 chown -R mysql.mysql /application/mysql/data/

 #初始化程序

 /application/mysql/scripts/mysql_install_db --basedir=/application/mysql --datadir=/application/mysql/data --user=mysql

 #配置启动脚本进行授权

 cp /application/mysql/support-files/mysql.server  /etc/init.d/mysqld

 chmod +x /etc/init.d/mysqld

 sed -i 's#/usr/local/mysql#/application/mysql#g' /application/mysql/bin/mysqld_safe /etc/init.d/mysqld

 \cp /application/mysql/support-files/my-default.cnf /etc/my.cnf

 #优化：将命令增加到环境变量

 echo 'export PATH=/application/mysql/bin:$PATH' >>/etc/profile

 source /etc/profile

 #加入开机自启动

 chkconfig --add mysqld

 chkconfig mysqld on

 #启动服务

 /etc/init.d/mysqld start

安装完后执行ps-ef | grep mysql查看

[root@web01 tools]# ps -ef | grep mysql
root 10937 1 0 19:53 pts/2 00:00:00 /bin/sh /application/mysql/bin/mysqld_safe --datadir=/application/mysql/data --pid-file=/application/mysql/data/web01.pid
mysql 11053 10937 0 19:53 pts/2 00:00:01 /application/mysql/bin/mysqld --basedir=/application/mysql --datadir=/application/mysql/data --plugin-dir=/application/mysql/lib/plugin --user=mysql --log-error=/application/mysql/data/web01.err --pid-file=/application/mysql/data/web01.pid
root 11162 10821 0 20:19 pts/2 00:00:00 grep mysql

给mysql用户设置密码

[root@web01 ~]# mysqladmin -u root password 'oldboy123'   --设置root密码为oldboy123
Warning: Using a password on the command line interface can be insecure.
[root@web01 ~]# mysql -uroot -poldboy123　　　　　　　　--登录root用户
Warning: Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 6
Server version: 5.6.34 MySQL Community Server (GPL)

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> quit      --退出
Bye