mysql的建表赋权_mysql新建用户表，赋权，远程登陆

建表，赋权，远程登陆

insert into mysql.user(Host,User,Password) values("localhost","tinytest",password("tinytest"));

flush privileges;

create database tinytest CHARACTER SET 'utf8' COLLATE 'utf8_general_ci';

grant all privileges on tinytest.* to tinytest@localhost identified by 'tinytest';

flush privileges;

解决

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES).

$ mysql

+--------------------+

| Database |

+--------------------+

| information_schema |

+--------------------+ 当进入mysql的时候看不到mysql数据库

解决方法，启动mysqld服务的时候带参数

$ mysqld --skip-grant-tables

$ mysql -u root mysql

mysql> UPDATE user SET Password=PASSWORD('my_password') where USER='root';

mysql> FLUSH PRIVILEGES;