1. 在Linux 安装MySQL后,关于root的密码修改。
linux安装后,然后自动生成一个复杂的密码,其是记录在/var/log/mysqld.log中
sudo grep 'temporary password' /var/log/mysqld.log
然后使用mysql命令登陆进去,修改密码即可
mysql -uroot -p
ALTER USER 'root'@'localhost' identified BY 'newPassword';
如果MySQL版本是5.7以下的,是使用
SET PASSWORD FOR ''@'localhost' = PASSWORD('new_password');
2. 用户的新建、修改密码与删除
2.1 如果是root登陆进行,可以使用下面的sql语句查看数据库中有已经有哪些用户
select user,host from mysql.user ;
2.2 创建用户并赋于某数据库的操作权限
create user 'user_name'@'user_host' identified by 'password' ;
grant all privileges on db_name.* to 'user_name'@'user_host' ;
2.3 用户的密码修改
alter user 'user_name'@'user_host' identified by 'newpassword' ;
2.4 删除用户
drop user 'user_name'@'user_host';
2.5 收回用户权限
revoke all privileges on db_name from 'user_name'@'user_host' ;
3. 数据库创建并指定character set
drop database if exists db_name ;
create database db_name
character set character_set_name collate collation_name ;
4. 数据库删除
drop database if exists db_name;
5. 查看数据库的character set
use db_name
select @@character_set_database, @@collation_database ;
6. 查看mysql支持的character set
SELECT CHARACTER_SET_NAME, DESCRIPTION
FROM INFORMATION_SCHEMA.CHARACTER_SETS
WHERE DESCRIPTION LIKE '%Chin%' ;
7. 查看mysql的外键约束名
SELECT
TABLE_NAME,COLUMN_NAME,CONSTRAINT_NAME, REFERENCED_TABLE_NAME,REFERENCED_COLUMN_NAME
FROM
INFORMATION_SCHEMA.KEY_COLUMN_USAGE
WHERE
REFERENCED_TABLE_SCHEMA = 'db_name' ;