在Arch Linux中安装MySQL

最近在用ArchLinux在虚拟机里学习Linux。现在想在ArchLinux中安装WordPress，首先就需要安装MySql数据库。但是在MySql被Oracle收购之后，很多开源支持者就转而使用MariaDb了。不过MariaDb也和MySql兼容的，所以基本不用有什么担心。由于ArchLinux只带了MariaDb，所以我们就用MariaDb来代替MySql。安装MariaDb和其客户端工具，sudo pacman -S mariadb mariadb-clients安装完成之后，会出现如何开启MariaDb的提示：

:: You need to initialize the MariaDB data directory prior to starting
the service. This can be done with mysql_install_db command, e.g.:
mysql_install_db –user=mysql –basedir=/usr –datadir=/var/lib/mysql

根据提示，我们运行如下命令就可以初始化MariaDb的数据目录了。sudo mysql_install_db --user=mysql --basedir=/usr --datadir=/var/lib/mysql在经过一长串提示信息之后，就会出现相应的如何开启MariaDb的帮助信息：

 To start mysqld at boot time you have to copysupport-files/mysql.server to the right place for your systemPLEASE REMEMBER TO SET A PASSWORD FOR THE MariaDB root USER ！To do so, start the server, then issue the following commands:"/usr/bin/mysqladmin" -u root password "new-password""/usr/bin/mysqladmin" -u root -h mypc password "new-password"Alternatively you can run:"/usr/bin/mysql_secure_installation"which will also give you the option of removing the testdatabases and anonymous user created by default.This isstrongly recommended for production servers.See the MariaDB Knowledgebase at http://mariadb.com/kb or theMySQL manual for more instructions.You can start the MariaDB daemon with:cd "/usr" ; /usr/bin/mysqld_safe --datadir="/var/lib/mysql"You can test the MariaDB daemon with mysql-test-run.plcd "/usr/mysql-test" ; perl mysql-test-run.plPlease report any problems at http://mariadb.org/jiraThe latest information about MariaDB is available at http://mariadb.org/.You can find additional information about the MySQL part at:http://dev.mysql.comSupport MariaDB development by buying support/new features from MariaDBCorporation Ab. You can contact us about this at sales@mariadb.com.Alternatively consider joining our community based development effort:http://mariadb.com/kb/en/contributing-to-the-mariadb-project/

同样根据提示，我们首先需要先启动MariaDb，sudo systemctl start mysqld然后为root用户设置一个新密码，mysqladmin -u root password "12345678" 然后尝试登录MariaDb，如果登录成功，说明配置完成了，mysql -uroot -p 12345678如果想要MariaDb开机自动启动，那么就运行以下命令，sudo systemctl enable mysqld本文永久更新链接地址