安装MySQL
1,准备编译环境
yum groupinstall "Server Platform Development" "Development tools" -y
yum install cmake -y
2,准备MySQL数据存放目录
mkdir /mnt/data
groupadd -r mysql
useradd -r -g mysql -s /sbin/nologin mysql
id mysql
3,更改数据目录属主和属组。
chown -R mysql:mysql /mnt/data
4,下载稳定版源码包解压编译。
wget https://downloads.mysql.com/archives/get/file/mysql-5.6.24.tar.gz
tar xvf mysql-5.6.24.tar.gz -C /usr/local/src
cd /usr/local/src/mysql-5.6.24
cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql \
-DMYSQL_DATADIR=/mnt/data \
-DSYSCONFDIR=/etc \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_ARCHIVE_STORAGE_ENGINE=1 \
-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \
-DWITH_READLINE=1 \
-DWITH_SSL=system \
-DWITH_ZLIB=system \
-DWITH_LIBWRAP=0 \
-DMYSQL_TCP_PORT=3306 \
-DMYSQL_UNIX_ADDR=/tmp/mysql.sock \
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci
make && make install
5,修改安装目录的属组为mysql
chown -R mysql:mysql /usr/local/mysql/
6,初始化数据库。
cd /usr/local/mysql
/usr/local/mysql/scripts/mysql_install_db --user=mysql --datadir=/mnt/data/
7,复制配置文件和启动脚本
cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
chmod +x /etc/init.d/mysqld
cp /usr/local/mysql/support-files/my-default.cnf /etc/my.cnf
8,设置开机自动启动
cd
chkconfig mysqld on
chkconfig --add mysqld
9,修改配置文件中的安装路径及数据目录存放路径
echo -e "basedir = /usr/local/mysql\ndatadir = /mnt/data\n" >> /etc/my.cnf
10,设置PATH环境变量
echo "export PATH=$PATH:/usr/local/mysql/bin" > /etc/profile.d/mysql.sh
source /etc/profile.d/mysql.sh
11,命令
service mysqld start
service mysqld stop
service mysqld restart
安装完成默认为空,设置密码
set password for 'root'@'localhost'=password('newpasswd');
MySQL修改密码:https://blog.csdn.net/qq_34939371/article/details/102525018
远程连接(阿里云安全组需要配置相关规则)
#登陆mysql
$ mysql -uroot -p
mysql> use mysql;
mysql> update user set host = '%' where user = 'root';
mysql> select user, host from user; # 查看是否已经有 user=‘root’ 的 host 变成 %
mysql>flush privileges; # 刷新权限