WIN10安装mariadb10.4

进入mariadb目录
管理员身份运行cmd
data目录下.err是错误日志

  1. # 安装
  2. mysqld.exe --install mariadb
  3. # 初始化
  4. mysql_install_db
  5. # 启动 可能会报1067错误 是因为my.ini中有的路径不存在 优先根目录my.ini 其次加载data中的my.ini
  6. net start mariadb
  7. # 登录
  8. mysql -u root -p
  9. # 关闭
  10. net stop mariadb
  11. # 删除
  12. sc delete mariadb

LINUX安装mariadb10.4

下载地址

  1. cd /soft/bak
  2. touch /etc/yum.repos.d/mariadb.repo
  3. echo "# MariaDB 10.4 CentOS repository list - created 2020-10-23 08:02 UTC
  4. # http://downloads.mariadb.org/mariadb/repositories/
  5. [mariadb]
  6. name = MariaDB
  7. baseurl = http://yum.mariadb.org/10.4/centos7-amd64
  8. gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
  9. gpgcheck=1" > /etc/yum.repos.d/mariadb.repo
  10. yum install -y MariaDB-server MariaDB-client
  11. sed -i 's/#bind-address=0.0.0.0/bind-address=0.0.0.0/' /etc/my.cnf.d/server.cnf
  12. systemctl start mariadb.service
  14. #通过systemctl list-unit-files --type=service查看服务名 或者是mysql.service 有可能是 mariadb.service 也有可能被disable
  15. #/usr/bin/mysql_secure_installation
  16. #systemctl enable mariadb
  17. #systemctl restart mariadb
  18. #mysql -uroot -p
  19. #CREATE DATABASE ssrpanel;
  20. #use ssrpanel;
  21. #source /www/ssrpanel/ssrpanel.sql;

远程登录授权

  1. #CREATE USER 'root'@'%' IDENTIFIED BY '@powerglq';
  2. #GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'IDENTIFIED BY '@powerglq' WITH GRANT OPTION;
  3. #use mysql;
  4. #update user set password=PASSWORD("@powerglq")where user="root";
  5. #GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY "@powerglq";
  6. #flush privileges;