mysql安装备录

最新推荐文章于 2024-08-05 22:53:58 发布

心清扬

最新推荐文章于 2024-08-05 22:53:58 发布

阅读量513

点赞数

本文链接：https://blog.csdn.net/u011052072/article/details/17028963

版权

进入mysql数据库软件
/usr/local/mysql/bin/mysql

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

GRANT ALL PRIVILEGES ON *.* TO 'dm'@'localhost' IDENTIFIED BY '123456' WITH GRANT OPTION;

GRANT ALL PRIVILEGES ON *.* TO 'dm'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;

出现错误：ERROR 1045 (28000): Access denied for user 'dm'@'localhost' (using password: YES)

执行以下语句

grant all privileges on mysql.* to dm@localhost identified by '123456';

flush privileges;

创建数据库:

CREATE DATABASE `share` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

CREATE DATABASE `card_1` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;