mariadb-5.5 Windows10安装
1、官网下载&＃xff1a;https://downloads.mariadb.org/
2、解压mariadb-5.5.58-winx64.zip&＃xff0c;目录C:\mariadb-5.5.58-winx64
3、复制目录下的my-small.ini文件&＃xff0c;命名为my.ini
[client]
default-character-set &＃61; utf8[mysqld]
basedir &＃61; C:\\mariadb-5.5.58-winx64
datadir &＃61; C:\\mariadb-5.5.58-winx64\\data
character_set_server &＃61; utf8
collation-server &＃61; utf8_general_ci[WinMySQLAdmin]
Server&＃61;C:\mariadb-5.5.58-winx64\bin\mysqld.exe
4、在环境变量的系统变量名Path中追加C:\mariadb-5.5.58-winx64\bin
5、管理身份打开Windows Powershell
mysqld --install 服务安装
mysqld --remove 服务卸载
net start mysql 启动服务
net stop mysql 关闭服务
6、变更密码
输入&＃xff1a;mysql -uroot -p 回车&＃xff0c;此时mysql默认无密码
SET PASSWORD FOR &＃39;root&＃39;&＃64;&＃39;localhost&＃39; &＃61; PASSWORD(&＃39;123456&＃39;);
Centos7安装
1、查看版本
yum list|grep mariadb
2、安装
yum install mariadb*
systemctl enable mariadb.service
systemctl start mariadb.service
3、设置密码
输入&＃xff1a;mysql -uroot -p 回车&＃xff0c;此时mysql默认无密码
SET PASSWORD FOR &＃39;root&＃39;&＃64;&＃39;localhost&＃39; &＃61; PASSWORD(&＃39;123456&＃39;);
4、权限配置
GRANT ALL PRIVILEGES ON *.* TO &＃39;root&＃39;&＃64;&＃39;%&＃39; IDENTIFIED BY &＃39;123456&＃39; WITH GRANT OPTION;
FLUSH PRIVILEGES;
5、修改默认端口
修改配置文件/etc/my.cnf
[client]
port &＃61; 7001
socket &＃61; /var/lib/mysql/mysql.sock
default-character-set&＃61;utf8[mysqld]
bind-address &＃61; 0.0.0.0
port &＃61; 7001[mysql]
no-auto-rehash
default-character-set&＃61;utf8
京公网安备 11010802041100号