MySQL介绍以及安装8.0版本

[root@localhostmysql]# bin/mysqld --initialize --user=mysql -basedir=/data/mysql
--datadir=/data/mysql/data
[root@localhostmysql]# bin/mysqld_safe--basedir=/data/mysql-datadir=/data/mysql/data --user=mysql &

[root@localhost bin]# /etc/init.d/mysql.server start
/etc/init.d/mysql.server: line 239: my_print_defaults: command not found
/etc/init.d/mysql.server: line 259: cd: /usr/local/mysql: No such file or directory
Starting MySQL ERROR! Couldn‘t find MySQL server
(/usr/local/mysql/bin/mysqld_safe)

[root@localhost ~]# cat /etc/my.cnf
[mysqld]
basedir=/data/mysql
datadir=/data/mysql/data
# 在启动
[root@localhost ~]# /etc/init.d/mysql.server start
Starting MySQL SUCCESS!

mysql> set password=password(‘mysql‘);   
ERROR 1064 (42000): You have an error in your SQL syntax;
check the manual that corresponds to your MySQL server version
for the right syntax to use near ‘password(‘mysql‘)‘ at line 1
# 修改root初始密码为123456
mysql> alter user root@localhost identified by ‘123456‘;
Query OK, 0 rows affected (0.01 sec)

# 进行移动data数据文件路径。
# 创建一个存放数据的目录。
[root@zhang01 ]# mkdir -p /data/mysql/
# 切换进行这个目录。
[root@zhang01 mysql]# cd /data/mysql/
# 把mysql数据的目录移动到这个目录下。
[root@zhang01 mysql]# mv /usr/local/mysql/data ./
# 编辑配置文件。修改data路径。
[root@zhang01 mysql]# cat /etc/my.cnf
[mysqld]
datadir=/data/mysql/data

MySQL介绍以及安装8.0版本

标签：add   官网   流行   区别   print   and   ons   接口   延迟