注:centos7系统,安装mysql默认的是mariadb
首先运行
yum install mysql mysql-server
不过我运行后 开启mysql 的时候总是报这个错误
[root@ajaing-tuzi ~]# service mysql start
Redirecting to /bin/systemctl start mysql.service
Failed to start mysql.service: Unit mysql.service failed to load: No such file or directory.
[root@ajaing-tuzi ~]# /etc/init.d/mysql status
-bash: /etc/init.d/mysql: 没有那个文件或目录
[root@ajaing-tuzi ~]# systemctl enable mysql.service
Failed to execute operation: Access denied
[root@ajaing-tuzi ~]# systemctl enable mysql.service
Failed to execute operation: Access denied
[root@ajaing-tuzi ~]# mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
[root@ajaing-tuzi ~]# cd var/ib/mysql
我怀疑肯定是少了什么东西
确认是否已经安装了所有的mariadb所需要的库
[root@ajaing-tuzi ~]# sudo yum -y install mariadb*
接下来是最重要的(下面的两条要用root权限)
systemctl start mariadb.service
systemctl enable mariadb.service
不过我在运行第一条命令的时候 暴了个错
[root@ajaing-tuzi etc]# systemctl enable mariadb.service
Created symlink from /etc/systemd/system/multi-user.target.wants/mariadb.service to /usr/lib/systemd/system/mariadb.service.
[root@ajaing-tuzi etc]# journalctl -xe
If you believe that mysqld should be allowed create access on the mysql.sock sock_file by default.
Then you should report this as a bug.
You can generate a local policy module to allow this access.
Do
allow this access for now by executing:
# grep mysqld /var/log/audit/audit.log | audit2allow -M mypol
# semodule -i mypol.pp
1月 17 20:09:22 ajaing-tuzi.servicr2 dbus-daemon[619]: 'list' object has no attribute 'split'
1月 17 20:09:23 ajaing-tuzi.servicr2 systemd[1]: mariadb.service: control process exited, code=exited status=1
1月 17 20:09:23 ajaing-tuzi.servicr2 systemd[1]: Failed to start MariaDB database server.
-- Subject: Unit mariadb.service has failed
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Unit mariadb.service has failed.
--
-- The result is failed.
1月 17 20:09:23 ajaing-tuzi.servicr2 systemd[1]: Unit mariadb.service entered failed state.
1月 17 20:09:23 ajaing-tuzi.servicr2 systemd[1]: mariadb.service failed.
1月 17 20:09:23 ajaing-tuzi.servicr2 polkitd[872]: Unregistered Authentication Agent for unix-process:5265:1558350 (system bus name :1.98, object path /org/freedesktop/PolicyKit1/Authenticati
1月 17 20:09:29 ajaing-tuzi.servicr2 polkitd[872]: Registered Authentication Agent for unix-process:5564:1560573 (system bus name :1.102 [/usr/bin/pkttyagent --notify-fd 5 --fallback], object
1月 17 20:09:29 ajaing-tuzi.servicr2 systemd[1]: Reloading.
1月 17 20:09:29 ajaing-tuzi.servicr2 systemd[1]: [/usr/lib/systemd/system/initial-setup-graphical.service:14] Support for option SysVStartPriority= has been removed and it is ignored
1月 17 20:09:29 ajaing-tuzi.servicr2 systemd[1]: [/usr/lib/systemd/system/initial-setup-text.service:21] Support for option SysVStartPriority= has been removed and it is ignored
1月 17 20:09:29 ajaing-tuzi.servicr2 systemd[1]: Configuration file /usr/lib/systemd/system/auditd.service is marked world-inaccessible. This has no effect as configuration data is accessible
1月 17 20:09:29 ajaing-tuzi.servicr2 systemd[1]: Configuration file /usr/lib/systemd/system/ebtables.service is marked executable. Please remove executable permission bits. Proceeding anyway.
1月 17 20:09:29 ajaing-tuzi.servicr2 systemd[1]: Configuration file /usr/lib/systemd/system/wpa_supplicant.service is marked executable. Please remove executable permission bits. Proceeding a
1月 17 20:09:29 ajaing-tuzi.servicr2 polkitd[872]: Unregistered Authentication Agent for unix-process:5564:1560573 (system bus name :1.102, object path /org/freedesktop/PolicyKit1/Authenticat
lines 3248-3277/3277 (END)
过后 我检查了下配置文件中的目录 修改后成功启动
[root@ajaing-tuzi etc]# vim my.cnf
[root@ajaing-tuzi etc]# systemctl start mariadb.service
[root@ajaing-tuzi etc]# systemctl enable mariadb.service
[root@ajaing-tuzi etc]# mysql -u root -p
Enter password:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 2
Server version: 5.5.44-MariaDB MariaDB Server
Copyright (c) 2000, 2015, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| test |
+--------------------+
4 rows in set (0.00 sec)
MariaDB [(none)]>