Mysql数据库安装

it2022-05-05  103

下载tar包 安装包下载:https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.25-linux-glibc2.12-x86_64.tar.gz 将mysql安装到/usr/local/mysql下 重命名mv /usr/local/mysql-5.7.25-linux-glibc2.12-x86_64 /usr/local/mysql移动mv mysql-5.7.25-linux-glibc2.12-x86_64 /usr/local/解压tar -xvf mysql-5.7.25-linux-glibc2.12-x86_64.tar.gz 新建data目录 mkdir /usr/local/mysql/data 新建mysql用户、mysql用户组 mysql用户组:groupadd mysqlmysql用户:useradd mysql -g mysql 将/usr/local/mysql的所有者及所属组改为mysql chown -R mysql.mysql /usr/local/mysql 安装mysql 执行命令:/usr/local/mysql/bin/mysqld --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data --initialize编辑/etc/my.cnf [mysqld] datadir=/usr/local/mysql/data basedir=/usr/local/mysql socket=/tmp/mysql.sock user=mysql port=3306 character-set-server=utf8 # 取消密码验证 skip-grant-tables symbolic-links=0 [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid 开启服务 将mysql加入服务  cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql开机自启:chkconfig mysql on开启服务:service mysql start 设置密码 登录(由于/etc/my.cnf中设置了取消密码验证,所以此处密码任意)/usr/local/mysql/bin/mysql -u root -p操作mysql数据库 use mysql;修改密码

      update user set authentication_string=password('你的密码') where user='root';

      flush privileges;

将/etc/my.cnf中的skip-grant-tables删除登录再次设置密码(不知道为啥如果不再次设置密码就操作不了数据库了) /usr/local/mysql/bin/mysql -u root -pALTER USER 'root'@'localhost' IDENTIFIED BY '修改后的密码'; 允许远程连接 /usr/local/mysql/bin/mysql -u root -puse mysql;update user set host='%' where user = 'root';flush privileges;

目录

https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.25-linux-glibc2.12-x86_64.tar.gz

/usr/local/mysql/bin/mysqld --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data --initialize



最新回复(0)