Linux

修改mysql数据库位置

2020年 8月 26日 / 
 /etc/mysql/mariadb.conf.d/50-server.cnf

[mysqld]

#
# * Basic Settings
#
user            = mysql
pid-file        = /var/run/mysqld/mysqld.pid
socket         = /var/run/mysqld/mysqld.sock
port            = 3306
basedir         = /usr
#datadir                = /var/lib/mysql
# 修改为数据库位置
datadir = /home/www/mysqldata
tmpdir          = /tmp
lc-messages-dir = /usr/share/mysql
skip-external-locking

# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
# 允许所有IP连接
#bind-address           = 127.0.0.1  


如果启动时[Warning] Can't create test file /home/johndoe/UserDatabases/mypcname.lower-test
修改/lib/systemd/system/mariadb.service
ProtectHome=true为false

ibdata1过大
[mysqld]下增加下面配置
innodb_file_per_table=1

修改root密码
MariaDB [(none)]> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'PASSWORD' WITH GRANT OPTION;
Query OK, 0 rows affected (0.00 sec)

留言