MYSQL8.0 --- liunx系统安装

linux环境安装ubutun 系统查看是否安装libaio:dpkg -s libaioubutun 系统安装sudo apt-get install libaio-devsudo apt-get install libaio-dev第一种 tar包安装1、官网下载软件包MySQL :: Download MySQL Community Server (Archived Versions)2、将软件包放置/usr/local目录下解压包xz -d mysql-8.0.32-linux-glibc2.12-x86_64.tar.xztar xvf mysql-8.0.32-linux-glibc2.12-x86_64.tartar jvf解压3、重命名软件包4、新增用户名和组授权目录groupadd mysqluseradd -g mysql mysqlchown -R mysql:mysql /usr/local/mysql/5、mysql下新建data目录6、编辑/etc/my.cnfchmod 640 /etc/my.cnf[mysqld]port3306usermysqlbasedir/usr/local/mysqldatadir/usr/local/mysql/data#data可设置/opt/mysql/datasocket/tmp/mysql.socklog-error/usr/local/mysql/data/mysql.errpid-file/usr/local/mysql/data/mysql.pid#character configcharacter_set_serverutf8mb4如果error放在/opt/mysql下面设置目录权限7777、切换bin下初始化基础信息./mysqld --defaults-file/etc/my.cnf --basedir/usr/local/mysql/ --datadir/usr/local/mysql/data --usermysql --initialize会自动生成密码密码在mysql.err文件中查看密码如果data 设置其他目录./mysqld --defaults-file/etc/my.cnf --initialize-insecure --usermysql --basedir/usr/local/mysql --datadir/opt/mysql/data--initialize会生成随机密码--intialize-insecure初始化无密码生成默认密码8、添加mysql服务到系统并设置权限9、添加系统服务并启动数据库查看数据库状态chkconfig --add mysql启动服务/etc/init.d/mysql startservice mysql start10、将服务添加到启动PATH目录下ln -s /usr/local/mysql/bin/mysql /usr/bin/11、登录数据库使用上面密码mysql -u root -p12、修改root密码alter user rootlocalhost identified with mysql_native_password by 123456;flush privileges;重置mysql的root密码1、停止mysql的进程和服务killall -TERM mysqld”命令停止所有的mysqld进程service mysql stop2、进入bin目录./mysqld_safe --skip-grant-tables --usermysql 3、重新打开新终端mysql -u root -p 免密进入设置空格密码use mysql;update user set authentication_string where user root;flush privileges;4、杀掉启动 --skip-grant-tables的mysql进程5、启动mysql服务6、免密登录mysql -u root -puse mysql;alter user rootlocalhost identified with mysql_native_password by root;错误ERROR 1396 (HY000): Operation ALTER USER failed for rootlocalhost解析查root用%表示授予root用户的host可以从任何主机的所有权限localhost 标识只能允许本地访问图中设置%修改密码改成%解决办法use mysql;alter user root% identified with mysql_native_password by root;flush privileges;7、使用新密码正常登录错误日志1、service mysql start 启动服务报错mysql: error while loading shared libraries: libtinfo.so.5: cannot open shared object file: No such file or directory解决办法ubutun系统apt-get install install libncurses*centos系统yum install libncurses*2、service mysql start 启动服务报错mysql :mysql is neither service nor target!? suse12系统解决办法systemctl unmask mysql.serviceservice mysql start3、10060 mysql_mysql错误Cant connect to MySQL server (10060)可能是你的帐号不允许从远程登陆只能在localhost。登入mysql后更改 mysql 数据库里的 user 表里的 host 项从localhost改称%解决办法use mysql;update user set host % where user root;flush privileges;select host, user from user;4、连接MySQL出现ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock解析找到mysql.sock文件的位置一般mysql.sock会在/var/lib/mysql/mysql.sock 或者/var/lib/mysql.sock一般写到MySQL配置文件 /etc/my.cnf里面,找到sock字段 修改为 /var/lib/mysql/mysql.sock 或/var/lib/mysql.sock但是MySQL实际是会到/tmp 目录下找mysql.sock 文件。我们可以将var/lib/mysql/mysql.sock 软连接到 /tmp/mysql.sock解决办法ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock5、ERROR 1045 (28000): Access denied for user rootlocalhost一般密码错误6、Warning: World-writable config file /etc/my.cnf is ignoredERROR 2002 (HY000): Cant connect to local MySQL server through socket /tmp/mysqld.sock解析/etc/my.cnf权限全局可写任何一个用户都可以写。mysql担心这种文件被其他用户恶意修改所以忽略掉这个配置文件。导致无法启动解决办法chmod 640 /etc/my.cnf参考Linux-安装MySQL详细教程_linux安装mysql-CSDN博客