1. 下载PKG链接🔗
https://mariadb.com/downloads/#mariadb_platform-mariadb_server
选择下载的安装包
2. 安装流程参考视频
https://www.youtube.com/watch?v=dWPMkKGsLis
3. 完成上述步骤之后
- 确定root用户没有密码但是还是登陆不了并且报错如下
ERROR 1698 (28000): Access denied for user 'root'@'localhost'
To log in to MariaDB as root, you will need to become root on the OS; the preferred mechanism for this is to use sudo, like this:
sudo /usr/local/mariadb/server/bin/mariadb
- 执行该命令之后输入密码，这里的密码是电脑管理员的密码
以管理员身份登陆mariadb
- 登陆成功后执行下列命令
// 使用mysql数据库
use mysql;
// 更改root用户的密码(这步可选)
update user set password=[你要设置的密码] where user = 'root';
// 打开远程访问权限 '123456' 是 root用户密码
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'IDENTIFIED BY '123456' WITH GRANT OPTION;
// 刷新权限
flush privileges;
网友评论