## Arch linux 安装 mysql 没有默认数据库，要先初始化
```
mariadb-install-db --user=mysql --basedir=/usr --datadir=/var/lib/mysql
```

## mysql root 帐户没有密码没法登陆操作
```
systemctl stop mysql
mysqld_safe --skip-grant-tables &
mysql -uroot
```

## 完整代码解决方案(arch linux 部分适用)
```
Full code solution
1. run bash commands
1. first, run these bash commands

sudo /etc/init.d/mysql stop # stop mysql service
sudo mysqld_safe --skip-grant-tables & # start mysql without password
# enter -> go
mysql -uroot # connect to mysql

2. then run mysql commands => copy paste this to cli manually

use mysql; # use mysql table
update user set authentication_string=PASSWORD("") where User='root'; # update password to nothing
update user set plugin="mysql_native_password" where User='root'; # set password resolving to default mechanism for root user

flush privileges;
quit;

3. run more bash commands

sudo /etc/init.d/mysql stop 
sudo /etc/init.d/mysql start # reset mysql
# try login to database, just press enter at password prompt because your password is now blank
mysql -u root -p 

4. Socket issue (from your comments)
When you see a socket error, a community came with 2 possible solutions:

sudo mkdir -p /var/run/mysqld; sudo chown mysql /var/run/mysqld
sudo mysqld_safe --skip-grant-tables &
(thanks to @Cerin)

Or

mkdir -p /var/run/mysqld && chown mysql:mysql /var/run/mysqld  
(thanks to @Peter Dvukhrechensky)
```

### 下载WordPress安装包并解压，添加wp用户名
```
wget http://wordpress.org/latest.tar.gz
tar -xzvf latest.tar.gz

mysql -u root

mysql> CREATE DATABASE wp2020;
mysql> GRANT ALL PRIVILEGES ON wp2020.* TO "wp2020"@"127.0.0.1"  IDENTIFIED BY "wp2020passwd";
FLUSH PRIVILEGES;

```