MySQL管理方式
- mysql命令的局限性?
- 是否有图形化,更加直观的管理软件?
- 能通过web界面访问?
常见的管理工具
类型 | 界面 | 操作系统 | 说明 |
---|---|---|---|
mysql | 命令行 | 跨平台 | MySQL官方bundle包自带 |
MySQL-workbench | 图形 | 跨平台 | MySQL官方提供 |
MySQL-Front | 图形 | Windows | 开源,轻量级客户端软件 |
Navicat | 图形 | Windows | 专业,功能强大,商业版 |
phpMyAdmin | 浏览器 | 跨平台 | 开源,需LANP平台 |
部署PHPMyAdmin
- 基本思路
1.部署环境LAMP
2.启动httpd服务程序
3.解压phpMyAdmin包
4.配置config.inc,php,指定MySQL服务器地址
5.浏览器访问,使用数据库管理员root登录
第一步:安装MySQL数据库服务(已安装请忽略)
解包: mysql-5.7.17.tar 和 phpMyAdmin-2.11.11-all-languages.tar.gz
mysql链接提取码: em6w
phpMyAdmin链接 提取码: 4gcd
[root@host51 ~]# ls /opt/mysql
libev-4.15-1.el6.rf.x86_64.rpm
maxscale-2.1.2-1.rhel.7.x86_64.rpm
mha-soft-student
Mycat-server-1.6-RELEASE-20161028204710-linux.tar.gz
my.cnf
mysql-5.7.17.tar
mysql-5.7.20-linux-glibc2.12-x86_64.tar.gz
percona-xtrabackup-24-2.4.7-1.el7.x86_64.rpm
phpMyAdmin-2.11.11-all-languages.tar.gz
[root@host51 ~]# tar zxf /opt/mysql/mysql-5.7.17.tar -C /opt
[root@host51 ~]# tar zxf /opt/mysql/phpMyAdmin-2.11.11-all-languages.tar.gz -C /opt
[root@host51 opt]# ls
mysql
mysql-community-client-5.7.17-1.el7.x86_64.rpm
mysql-community-common-5.7.17-1.el7.x86_64.rpm
mysql-community-devel-5.7.17-1.el7.x86_64.rpm
mysql-community-embedded-5.7.17-1.el7.x86_64.rpm
mysql-community-embedded-compat-5.7.17-1.el7.x86_64.rpm
mysql-community-embedded-devel-5.7.17-1.el7.x86_64.rpm
mysql-community-libs-5.7.17-1.el7.x86_64.rpm
mysql-community-libs-compat-5.7.17-1.el7.x86_64.rpm
mysql-community-minimal-debuginfo-5.7.17-1.el7.x86_64.rpm
mysql-community-server-5.7.17-1.el7.x86_64.rpm
mysql-community-test-5.7.17-1.el7.x86_64.rpm
phpMyAdmin-2.11.11-all-languages
2.安装MySQL数据库服务
[root@host51 ~]# yum -y install /opt/mysql-community-*.rpm
[root@host51 ~]# systemctl start mysqld
注意: 新安装的myslqd初始登录步骤:
[root@host51 ~]# grep "password" /var/log/mysqld.log
2020-02-13T06:25:51.681618Z 1 [Note] A temporary password is generated for root@localhost: ,gtruI,fw78h
[root@host51 ~]# mysql -uroot -p",gtruI,fw78h" ##特殊符号用单引''
mysql> alter user root@"localhost" identified by "123qqq...A"; ##首次登录必须修改密码
3.安装httpd服务
[root@host51 ~]# cd /opt
[root@host51 opt]# yum -y install httpd php php-mysql
[root@host51 opt]# systemctl enabled httpd
[root@host51 opt]# mv phpMyAdmin-2.11.11-all-languages/* /var/www/html/phpmyadmin
4.配置图形化MySQL服务的配置文件
[root@host51 opt]# cd /var/www/html/phpmyadmin
[root@host51 phpmyadmin]# cp config.sample.inc.php config.inc.php
[root@host51 phpmyadmin]# vim config.inc.php
17 $cfg['blowfish_secret'] = 'mysql123'; /* YOU MUST FILL IN THIS FOR COOKIE AU TH! */
31 $cfg['Servers'][$i]['host'] = 'localhost';
##17行指定网页cookie参数,没指定cookie参数就登录不进页面
##31行指定服务器ip地址,本机代表localhost
##登录页面的用户和密码填写数据库的用户及密码
下面演示没有修改17行的cookie参数
修改了17行的cookie参数后$cfg[‘blowfish_secret’] = ‘mysql123’;密码自定义
再次登录
创建数据库 (名称随意)
创建表格(内容类型自定义)
插入字段
在命令行查看
mysql> show databases; ##可以看到db4库
+--------------------+
| Database |
+--------------------+
| information_schema |
| db4 |
| mysql |
| performance_schema |
| sys |
+--------------------+
7 rows in set (0.00 sec)
mysql> use db4; ##进入db4
mysql> show tables; ##查看表格
+---------------+
| Tables_in_db4 |
+---------------+
| student |
+---------------+
2 rows in set (0.00 sec)
mysql> desc student; ##查看表结构
+-------+---------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+---------------------+------+-----+---------+-------+
| name | varchar(15) | NO | | NULL | |
| age | tinyint(3) unsigned | NO | | 19 | |
| class | tinyint(3) unsigned | NO | | NULL | |
+-------+---------------------+------+-----+---------+-------+
3 rows in set (0.00 sec)
##以上结果得知图形化操作跟命令行操作是一模一样的,图形化比较方便