Linux下安装独立MySQL

sudo apt-get install openssh-server                                                   #安装SSH服务
                                                                                                #上传MySQL的安装包到用户主目录   wget http://192.168.81.117/software/mysql-5.7.10-linux-glibc2.5-x86_64.tar.gz
tar -xzvf mysql-5.7.10-linux-glibc2.5-x86_64.tar.gz                     #解压
cd /usr/local
sudo ln -s /home/ndct/mysql-5.7.10-linux-glibc2.5-x86_64 mysql       #创建链接
cd mysql
sudo apt-get install libaio1                                                                 #安装依赖的库
sudo groupadd mysql                                                                         #创建用户组
sudo useradd -r -g mysql -s /bin/false mysql                                       #创建用户
sudo chown -R mysql .                                                                        #修改所有者
sudo chgrp -R mysql .                                                                          #修改所有者
sudo bin/mysqld --initialize --user=mysql                        #这里会生成随机的初始密码，后面要用到CAk+fk_yk5lr       Ar7tdVoFEP)u       ,OwLtY)Z5u#2       &gA7yPu&+o:?
sudo bin/mysql_ssl_rsa_setup
sudo chown -R root .                                                       #mysql主目录归还给root用户
sudo chown -R mysql data                                              #data目录分配给mysql用户
sudo cp support-files/my-default.cnf /etc/my.cnf          # sudo service mysql restart 修改配置后，需要重启mysql服务
sudo cp support-files/mysql.server /etc/init.d/mysql         #添加服务
sudo update-rc.d mysql defaults                                      #设置开机自动启动
为了避免每次都输入mysql的全路径/usr/local/mysql/bin/mysql，可将其加入环境变量中，在/etc/profile最后加入两行命令：
MYSQL_HOME=/usr/local/mysql
export PATH=$PATH:$MYSQL_HOME/bin

sudo shutdown -r now                                             #重启服务器

mysql应该已经自动启动，如果要手动启动运行下面命令
sudo bin/mysqld_safe --user=mysql &       #命令后面加 & 表示此命令将在一个后台进程中继续执行，控制台归还用户

修改初始密码：
mysql > set password for 'root'@'localhost'='123xx456';

create database cm_acke default charset utf8 collate utf8_general_ci;
create user 'dev'@'%' identified by 'dev';
grant all privileges on cm_acke.* to dev;


dpkg -l             #查看已安装的包
cat XXX.txt        #显示文件内容