开心博客 - Day Day Coding, Day Day Happy!

引用地址centos安装配置mariadbwww.cnblogs.com/yhon...

2021-05-12 数据库 mysql centos mariaDB

1. 修改配置文件 Choose here javascripttypescripthtmlcssshellpythongolangjavacc++c#phprubyswiftkotlinscalarustdartelixirhaskellluaperlrsql 文件位置： /etc/mysql/mariadb.conf.d/50-server.cnf 大概26行，注释掉 bind_address=127.0.0.1 行 2. 增加“

2020-12-29 数据库 mysql mariaDB maria

win10下载zip源码安装包安装mysql8

一、下载mysql.com二、解压，并创建my.ini配置文件 Choose here javascripttypescripthtmlcssshellpythongolangjavacc++c#phprubyswiftkotlinscalarustdartelixirhaskellluaperlrsql [mysqld] default_authentication_plugin=mysql_native_password charact

2020-11-27 数据库 mysql

MySQL8.0修改用户密码

Choose here javascripttypescripthtmlcssshellpythongolangjavacc++c#phprubyswiftkotlinscalarustdartelixirhaskellluaperlrsql use mysql; alter user 'root'@'localhost' identified with mysql_native_password by 'root'; flush priv

2020-11-09 数据库 mysql 密码

MySQL错误：Access denied for user 'root'@'%' to database 的解决方法

MySQL报“Access denied for user 'root'@'%' to database”错误的解决方法执行 GRANT ALL PRIVILEGES ON test.* TO 'test_user'@'%' WITH GRANT OPTION 报错;错误原因user表中 'root'@'%' 没有grant的权限解决方法- **修改grant权限** ``` update mysql.user set Grant_priv='Y',Super_priv='Y' where user = 'roo

2019-07-29 数据库 mysql 权限报错

Hot

MySQL8授权root用户远端登录

开启MySQL8远端登录You are not allowed to create a user with GRANT创建用户 Choose here javascripttypescripthtmlcssshellpythongolangjavacc++c#phprubyswiftkotlinscalarustdartelixirhaskellluaperlrsql create user 'root'@'%' identified by

2019-07-29 数据库 mysql 远程登录