创建MySQL数据库用户

sql
阅读 40 收藏 0 点赞 0 评论 0

mysql.sql
#logged as root > mysql -u root -p
create database DATABASENAME character set utf8 collate utf8_general_ci;
create user DATABASEUSER@localhost identified by 'DATABASEUSER';
set password for DATABASEUSER@localhost = password('CHOOSE_PASSWORD');
grant select, insert, update, delete, create, drop, index, alter, create temporary tables, lock tables on DATABASENAME.* to DATABASEUSER@localhost;
flush privileges;
评论列表


问题


面经


文章

微信
公众号

扫码关注公众号