1. 連接mysql
~~~php
mysql - u root - p;
~~~
>[info] root 用戶名
>輸入命令之后 提示輸入輸入密碼
2. 創建外網連接用戶
~~~php
GRANT ALL PRIVILEGES ON *.* TO 'name'@'%' IDENTIFIED BY 'pwd' WITH GRANT OPTION;
grant all privileges on *.* to 'name'@'%' identified by 'pwd' with grant option;
grant select on database . * to 'name'@localhost identified by 'pwd';
~~~
>[info] name 表示創建的用戶名
> % 表示可以以任意方式連接
> pwd 用戶的登錄密碼
3. 查詢已經創建的用戶
~~~php
SELECT DISTINCT CONCAT('User: ''',user,'''@''',host,''';') AS query FROM mysql.user;
select distinct concat('user: ''',user,'''@''',host,''';') as query from mysql.user;
~~~
4. 退出 斷開連接
~~~php
exit;
~~~
5. 查看端口號
~~~php
show global variables like 'port';
~~~
6. 查看版本號碼
~~~php
select version();
~~~
