前言
本文介绍银河麒麟桌面操作系统V10上通过麒麟软件商店安装MySQL5.7、MySQL Workbench及其基本使用方法
一、安装MySQL5.7
点击UK图标、所有程序,找到麒麟软件商店
输入mysql
点击MySQL服务器下面的安装按钮
输入用户密码,点击授权
等待安装完成
二、安装MySQL Workbench
参考上面流程,继续安装workbench,点击MySQL工作台下面的安装按钮
输入密码,授权
等待安装完成
三、使用MySQL Workbench管理MySQL实例
启动mysql服务
输入以下指令,启动mysqld服务进程
sudo systemctl start mysql
输入以下指令,查看服务状态
sudo systemctl status mysql
检查端口监听状态
sudo netstat -lnetp | grep 3306
修改监听地址
注意mysqld监听的地址是127.0.0.1,将其修改成0.0.0.0,操作方法如下:
vim打开配置文件
sudo vim /etc/mysql/mysql.conf.d/mysql.conf
采用方向键,移动光标到箭头位置
输入指令i
进入编辑模式,将127.0.0.1改为0.0.0.0,按下Esc进入指令模式,输入指令:wq 保存退出
检查连接监听
设置root密码
mysql默认安装后,root是采用socket方式登陆,借助mysql字符界客户端授权root远程登陆
说明:auth_socket插件。该插件不关心,也不需要密码。它只检查用户是否使用UNIX套接字进行连接,然后比较用户名。注意采用sudo 切换到root权限
为了检点,直接删掉原来的root账户信息,创建一个新的
# sudo mysql[sudo] yeqiang 的密码:Welcome to the MySQL monitor. Commands end with ; or \g.Your MySQL connection id is 15Server version: 5.7.27-0kord0.16.04.1k2 (Kylin)Copyright (c) 2000, , Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.mysql> delete from mysql.user where user='root';Query OK, 2 rows affected (0.00 sec)mysql> grant all privileges on *.* to 'root'@'%' identified by 'rootpwd';Query OK, 0 rows affected, 1 warning (0.00 sec)mysql> flush privileges;Query OK, 0 rows affected (0.00 sec)mysql> select * from mysql.user where user='root';+------+------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+------------------+----------------+---------------------+--------------------+------------------+------------+--------------+------------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+----------------------+-----------------------+-------------------------------------------+------------------+-----------------------+-------------------+----------------+| Host | User | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv | Shutdown_priv | Process_priv | File_priv | Grant_priv | References_priv | Index_priv | Alter_priv | Show_db_priv | Super_priv | Create_tmp_table_priv | Lock_tables_priv | Execute_priv | Repl_slave_priv | Repl_client_priv | Create_view_priv | Show_view_priv | Create_routine_priv | Alter_routine_priv | Create_user_priv | Event_priv | Trigger_priv | Create_tablespace_priv | ssl_type | ssl_cipher | x509_issuer | x509_subject | max_questions | max_updates | max_connections | max_user_connections | plugin| authentication_string | password_expired | password_last_changed | password_lifetime | account_locked |+------+------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+------------------+----------------+---------------------+--------------------+------------------+------------+--------------+------------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+----------------------+-----------------------+-------------------------------------------+------------------+-----------------------+-------------------+----------------+| % | root | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | N| Y| Y| Y| Y | Y| Y | Y| Y | Y| Y| Y| Y | Y | Y | Y| Y| Y | Y || | | | 0 | 0 |0 |0 | mysql_native_password | *A7663C386E0231DEB41859368A584CDF1D355C29 | N| -12-08 16:39:19 | NULL | N |+------+------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+------------------+----------------+---------------------+--------------------+------------------+------------+--------------+------------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+----------------------+-----------------------+-------------------------------------------+------------------+-----------------------+-------------------+----------------+1 row in set (0.00 sec)mysql>
启动workbench
点击UK图标、所有程序、MySQL Workbench
本地连接自动出现了
右键,选择Edit Connection
点击Store in Keychain ...
输入密码,点击OK
测试连接
查看服务器状态
总结
借助麒麟应用商店,可以方便安装mysql及workbench。
注意:配置root账号是,原账号做了一定限制,为了简单起见,可参考本文先删除root账号信息,再通过grant创建。否则容易出现access denied 错误。