mysql 在linux下的操作
-
安装mysql客户端:
yum install mysql
安装mysql 服务器端:
yum install mysql-server
yum install mysql-devel
- 添加修改 etc/my.cnf character_set_server=utf8
- service mysqld start
-
Job for mysqld.service failed because the control process exited with error code. See "systemctl status mysqld.service" and "journalctl -xe" for details. [FAILED] 启动报错的话执行下面语句
mysql_install_db --user=mysql --ldata=/var/lib/mysql/
- mysql -u root -p 进入mysql控制台
- 开启远程被访问 修改mysql数据库下的user表
- 修改user表:update user set host = '%' where user = 'root'; 若本地不能访问,则可将update修改为insert