linux环境mysql安装
来源:互联网 发布:sql server安装包下载 编辑:程序博客网 时间:2024/05/29 18:32
一、mysql安装
安装mysql服务端
yum
install
mysql-server---服务器端
yum install mysql-devel ---
安装mysql客户端:
yum install mysql
二 . 修改mysql root密码
1. 修改MySQL的登录设置:
# vi /etc/my.cnf
在[mysqld]的段中加上一句:skip-grant-tables
例如:
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
skip-grant-tables
保存并且退出vi。
2.重新启动mysqld
# /etc/init.d/mysqld restart
Stopping MySQL: [ OK ]
Starting MySQL: [ OK ]
3.登录并修改MySQL的root密码
# /usr/bin/mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3 to server version: 3.23.56
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> USE mysql ;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> UPDATE user SET Password = password ( 'new-password' ) WHERE User = 'root' ;
Query OK, 0 rows affected (0.00 sec)
Rows matched: 2 Changed: 0 Warnings: 0
mysql> flush privileges ;
Query OK, 0 rows affected (0.01 sec)
mysql> quit
Bye
4.将MySQL的登录设置修改回来
# vi /etc/my.cnf
将刚才在[mysqld]的段中加上的skip-grant-tables删除
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
skip-grant-tables
保存并且退出vi。
2.重新启动mysqld
# /etc/init.d/mysqld restart
Stopping MySQL: [ OK ]
Starting MySQL: [ OK ]
3.登录并修改MySQL的root密码
# /usr/bin/mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3 to server version: 3.23.56
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> USE mysql ;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> UPDATE user SET Password = password ( 'new-password' ) WHERE User = 'root' ;
Query OK, 0 rows affected (0.00 sec)
Rows matched: 2 Changed: 0 Warnings: 0
mysql> flush privileges ;
Query OK, 0 rows affected (0.01 sec)
mysql> quit
Bye
4.将MySQL的登录设置修改回来
# vi /etc/my.cnf
将刚才在[mysqld]的段中加上的skip-grant-tables删除
保存并且退出vi。
5.重新启动mysqld
# /etc/init.d/mysqld restart
Stopping MySQL: [ OK ]
Stopping MySQL: [ OK ]
Starting MySQL: [ OK ]
三、增加访问权限配置(解决访问错误:如:ERROR 1044 (42000): Access denied for user ''@'localhost' to database)
mysql> use mysql
mysql> SELECT host,user,password,Grant_priv,Super_priv FROM mysql.user;
mysql> UPDATE mysql.user SET Grant_priv='Y', Super_priv='Y' WHERE User='root';
mysql> FLUSH PRIVILEGES;
mysql> GRANT ALL ON *.* TO 'root'@'localhost';
mysql> GRANT ALL ON *.* TO 'root'@'%'; -------允许ip访问控制
mysql> GRANT ALL ON *.* TO 'root'@'245.245.245.245';
mysql> GRANT ALL ON *.* TO 'root'@'127.0.0.1';
mysql> FLUSH PRIVILEGES;
阅读全文
0 0
- linux环境安装mysql
- linux环境mysql安装
- linux环境安装mysql
- linux环境安装mysql
- 【Mysql】Linux环境安装Mysql
- linux环境下安装mysql
- Linux环境下安装MySQL
- Linux环境下安装mysql
- Linux环境mysql源码安装
- linux环境下安装mysql
- Mysql-linux环境下安装
- linux 环境下安装mysql
- Linux环境下安装MySQL
- linux环境mysql 数据库安装
- linux环境的mysql安装
- Linux环境的AMP安装--MYSQL安装
- Linux环境下安装MySQL|Linux下Mysql安装教程
- Linux环境下MySQL-python安装过程
- 线性代数004之代数余子式
- firefox 安装Selenium IDE
- springMVC下前端ajax报404错误
- FFmpeg
- MySQL的聚集索引和非聚集索引
- linux环境mysql安装
- C++语言编程题1
- 装饰器之基本方法
- 十大Intellij IDEA快捷键
- 第三篇:显示cifar-10中的图片
- pyspider递归调用
- Smallest Minimum Cut(HDU 6214 dinic模板)
- bean之后创建dao
- CCF—日期计算 20150902