本文介绍了在AWS中mysql的下载以及相关的配置
一.通过yum下载mysql的相关文件.
1.进入etc文件目录.
cd /etc
2.下载mysql.
sudo yum install mysql
显示以下信息,表示下载并安装成功.
Installed:
mysql.noarch 0:5.5-1.6.amzn1
Dependency Installed:
mysql-config.x86_64 0:5.5.59-1.20.amzn1 mysql55.x86_64 0:5.5.59-1.20.amzn1
mysql55-libs.x86_64 0:5.5.59-1.20.amzn1
Complete!
3.下载mysql-server.
sudo yum install mysql-server
显示以下信息,表示下载并安装成功.
Installed:
mysql-server.noarch 0:5.5-1.6.amzn1
Dependency Installed:
mysql55-server.x86_64 0:5.5.59-1.20.amzn1
perl-Compress-Raw-Bzip2.x86_64 0:2.061-3.11.amzn1
perl-Compress-Raw-Zlib.x86_64 1:2.061-4.1.amzn1
perl-DBD-MySQL55.x86_64 0:4.023-5.23.amzn1
perl-DBI.x86_64 0:1.627-4.8.amzn1
perl-Data-Dumper.x86_64 0:2.145-3.5.amzn1
perl-IO-Compress.noarch 0:2.061-2.12.amzn1
perl-Net-Daemon.noarch 0:0.48-5.5.amzn1
perl-PlRPC.noarch 0:0.2020-14.7.amzn1
Complete!
4.下载mysql-devel.
sudo yum install mysql-devel
显示以下信息,表示下载并安装成功.
Installed:
mysql-devel.noarch 0:5.5-1.6.amzn1
Dependency Installed:
keyutils-libs-devel.x86_64 0:1.5.8-3.12.amzn1
krb5-devel.x86_64 0:1.15.1-8.43.amzn1
libcom_err-devel.x86_64 0:1.42.12-4.40.amzn1
libkadm5.x86_64 0:1.15.1-8.43.amzn1
libselinux-devel.x86_64 0:2.1.10-3.22.amzn1
libsepol-devel.x86_64 0:2.1.7-3.12.amzn1
libverto-devel.x86_64 0:0.2.5-4.9.amzn1
mysql55-devel.x86_64 0:5.5.59-1.20.amzn1
openssl-devel.x86_64 1:1.0.2k-12.109.amzn1
zlib-devel.x86_64 0:1.2.8-7.18.amzn1
Dependency Updated:
openssl.x86_64 1:1.0.2k-12.109.amzn1
Complete!
二.配置mysql.
1.进入mysql文件夹
cd /var/lib/mysql
2.将/var/lib路径下的mysql文件用户组设为mysql.
sudo chgrp -R mysql /var/lib/mysql
3.修改文件权限为可读可写可运行.
sudo chmod -R 770 /var/lib/mysql
4.开启mysql服务
sudo service mysqld start
显示mysql数据库正在初始化,之后开启mysql服务成功.
Initializing MySQL database: Installing MySQL system tables...
...
...
...
Starting mysqld: [ OK ]
5.设置mysql登录的账号和密码.
/usr/bin/mysqladmin -u root password root
以上第一个root为账号名,第二个root为密码
6.连接mysql
mysql -u root -p
会显示:
Enter password:
输入刚刚设置的密码root.
之后显示mysql欢迎提示和版本信息.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 5.5.59 MySQL Community Server (GPL)
7.显示当前所有的数据库.
mysql>show databases;
显示
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| test |
+--------------------+
8.使用mysql.
mysql>use mysql
9.创建新账号和密码,授予远程登录的任意ip全部权限.
grant all PRIVILEGES on *.* to root@'%' identified by 'root';
解释:
all PRIVILEGES指所有权限,也可以给予部分权限,如:
select,insert,update,delete,create,drop,index,alter,grant,references,reload,shutdown,process,file等.
第一个root为新的账号名.
第二个root为新账号密码.
*.*所有数据库的所有表.
%为所有ip,此处可指定单个ip.
某个ip用户例子:
grant select,insert,update,delete,create,drop on test_database.* to baby@123.123.123.123 identified by '123456';
表示:
授予ip为123.123.123.123的用户baby分配可对test_database数据库的所有表进行select,insert,update,delete,create,drop操作的权限,并设定口令为123.
三.连接mysql.
Mac本可以通过MysqlWorkbench工具进行连接.
输入账号root,密码root即可.
