安装mysql
- (1)下载mysql的安装包
mysql下载地址https://dev.mysql.com/downloads/mysql/
- (2) 解压
tar -zxvf mysql-5.6.45-linux-glibc2.12-x86_64.tar.gz
- (3) 添加用户组,并添加用户
groupadd mysql
useradd -r -g mysql mysql
- (4)进入安装mysql目录: cd /usr/local/mysql
- (5)修改当前目录拥有者为mysql用户: chown -R mysql:mysql ./
- (6)安装数据库:
./scripts/mysql_install_db --user=mysql
- (7)修改当前目录拥有者为root用户: chown -R root:root ./
- (8)修改my.cnf
vi /usr/local/mysql/my.cnf
- (9)将配置文件放到etc/my.cnf
cp mysql/my.cnf /etc/my.cnf
basedir = /usr/local/mysql
datadir = /data/mysql
port = 3306
- (10)初始化数据库
/usr/local/mysql/scripts/mysql_install_db --basedir=/usr/local/mysql --datadir=/data/mysql --user=mysql
basedir和datadir必须要my.cnf里的配置一样
- (11)配置mysql环境变量
vi /etc/profile
末尾添加以下内容
export MYSQL_HOME=/usr/local/mysql
export PATH=$PATH:$MYSQL_HOME/bin
- (12)启动mysql服务和添加开机启动mysql服务
cp support-files/mysql.server /etc/init.d/mysql
service mysql start
- (13)给mysql设置密码
mysql> use mysql;
mysql> UPDATE user SET Password = PASSWORD('newpass') WHERE user = 'root';
mysql> FLUSH PRIVILEGES;
登陆使用mysql -u root -p
输入密码即可
远程连接
由于远程的 MySQL 默认是不允许从远程访问他的,因此我们需要先进行授权,
- 使用的一种方法是从任何主机都可以连接到 MySQL 服务器,方法如下:
GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'%' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;
FLUSH PRIVILEGES;
- 如果你想允许用户myuser从ip为192.168.1.6的主机连接到mysql服务器,并使用mypassword作为密码
GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'192.168.1.6IDENTIFIED BY 'mypassword' WITH GRANT OPTION;
FLUSH PRIVILEGES;
- 如果你想允许用户myuser从ip为192.168.1.6的主机连接到mysql服务器的dk数据库,并使用mypassword作为密码
GRANT ALL PRIVILEGES ON dk.* TO 'myuser'@'192.168.1.6 IDENTIFIED BY 'mypassword' WITH GRANT OPTION;
FLUSH PRIVILEGES;
FLUSH PRIVILEGES;刷新权限