安装命令集如下:
shell> groupadd mysql
shell> useradd -r -g mysql -s /bin/false mysql
shell> cd /usr/local
shell> tar xvf /path/to/mysql-VERSION-OS.tar.xz
shell> ln -s full-path-to-mysql-VERSION-OS mysql
shell> cd mysql
shell> mkdir mysql-files
shell> chown mysql:mysql mysql-files
shell> chmod 750 mysql-files
shell> bin/mysqld --initialize --user=mysql
shell> bin/mysql_ssl_rsa_setup
shell> bin/mysqld_safe --user=mysql &
1、下载完成mysql源码包,得到初始密码后,运行mysqld_safe --user=mysql &
,出错信息如下“mysqld_safe error: log-error set to '/var/log/mariadb/mariadb.log', however file don't exists, Create writable for user 'mysql'. ”
此时需要在/etc/my.cnf文件中确认.log文件是否存在
2、使用bin/mysqld_safe启动mysql服务后,调用bin/mysqladmin version做测试,报错
查看/tmp/mysql.sock文件是否存在,如果不存在创建软连接,将mysql.sock连接到/etc/my.cnf配置文件中的[mysqld]下面的socket的值。
3、使用bin/mysql -u root -p进入mysql客户端,提示“you must reset your password using ALTER USER statement before executing this statement”
执行SET PASSWORD = '123456';
重置密码即可,不需要进入user表修改记录