mysql-学习-4-20170508

mysql-学习-4-20170508

 

MYSQL的用户管理：

-------------------------------------------------------------

5.7以前：

select user,host, password from mysql.user;

5.7以后：

select user,host ,authentication_string from mysql.user; 

 

 mysql的终结方法：

 ; 终结
\G 

 \c 终止

----------------------------------------------------------------------------------

查看加密密码是什么：

select password('wubxwubx'); 

----------------------------------------------------------------------------------------------

 flush privileges; 
mysql -S /tmp/mysql3306.sock -p 
192.168.11.100 3306  

 

 -----------------------------------------------------------------------------------------------------

localhost只能通过Socket文件来登录 

 

create user 'zst'@'db%.zst.com' identified by 'wubxwubx';

 

配合/etc/hosts  进行域名与ip的地址转换

192.168.11.101 db101.zst.com
192.168.11.102 db102.zst.com  

 

考题：ocp

'zst'@'%' identified by 'wubx'
'zst'@'192.168.11.101' identified by 'zst';
【管理员】吴炳锡(82565387)  21:16:48
从192.168.11.101 登录192.168.11.100 3306
mysql -h 192.168.11.100 -u zst -p  这事应该输入什么密码呢？ 应该输入zst 精确匹配原则，后缀精确匹配 

 

help set password;

 

set password=password('wubxwubx');

select current_user();

--------------------------------------------------------------------------------

select user,host,authentication_string from mysql.user;

desc mysql.user;

--------------------------------------------------------------------------------------------

 

 drop user wubx;

 

 drop user wubx@'%';

 

 show status , show variables;  

---------------------------------------------------------------------------

 

-----------------------------------------------------------------------------

 grant select on zstdb.* to 'r_zst'@'192.168.11.%';

---------------------------------------------------------------------------------------------

查看所有的权限： 

show privileges; 

------------------------------------------------------------------------------------------------

 help grant 

-------------------------------------------------------------------------------------------------------

------------------------------------------------------------------------------------------

 ------------------------------------------------------------------------------------------------------------

---------------------------------------------------------------------------------------------------------

-----------------------------------------------------------------------------------------------------------------------

mysqlsh 将来的趋势，用来处理json格式的数据

-----------------------------------------------------------------------------------------

---------------------------------------------------------------------------------------------------------

 /usr/local/mysql/bin/mysql_config_editor 

 login-path 

 

mysql提示符的修改：

prompt

 

 

 #mysql --help |grep my.cnf
                      order of preference, my.cnf, $MYSQL_TCP_PORT,
/etc/my.cnf /etc/mysql/my.cnf /usr/etc/my.cnf ~/.my.cnf  

后面的会把前面的覆盖掉

 

----------------------------------------------------------------------------------------------

------------------------------------------------------------------------------------------------------------

 

-----------------------------------------------------------------------------------------------

 

 

 建模用 power designer 或者workbench

 

 toad for mysql 开发神器

sqlyog