注: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)]>

Logo

魔乐社区(Modelers.cn) 是一个中立、公益的人工智能社区,提供人工智能工具、模型、数据的托管、展示与应用协同服务,为人工智能开发及爱好者搭建开放的学习交流平台。社区通过理事会方式运作,由全产业链共同建设、共同运营、共同享有,推动国产AI生态繁荣发展。

更多推荐