无法在mariadb服务器中使用mysql，没有明确的原因

Question

如果我只输入mysql -u root -p并输入密码到我的数据库中，但是现在每次我说mysql和类似于这个输出的任何选项时，我仍然会收到一条消息。

root@Dodge:~# mysql
Usage: /etc/init.d/mysql start|stop|restart|reload|force-reload|status
root@Dodge:~# mysql -u root
Usage: /etc/init.d/mysql start|stop|restart|reload|force-reload|status
root@Dodge:~# mysql -u root -p
Usage: /etc/init.d/mysql start|stop|restart|reload|force-reload|status

这个消息意味着服务没有运行对吗？但是，当我运行状态时，服务是活动的。

root@Dodge:~# systemctl status mysql
● mariadb.service - MariaDB 10.5.9 database server
     Loaded: loaded (/lib/systemd/system/mariadb.service; disabled; vendor preset: disabled)
     Active: active (exited) since Thu 2021-05-13 10:33:27 EET; 16min ago
       Docs: man:mariadbd(8)
             https://mariadb.com/kb/en/library/systemd/
      Tasks: 0 (limit: 9337)
     Memory: 0B
        CPU: 0
     CGroup: /system.slice/mariadb.service
root@Dodge:~# systemctl status mariadb
● mariadb.service - MariaDB 10.5.9 database server
     Loaded: loaded (/lib/systemd/system/mariadb.service; disabled; vendor preset: disabled)
     Active: active (exited) since Thu 2021-05-13 10:33:27 EET; 16min ago
       Docs: man:mariadbd(8)
             https://mariadb.com/kb/en/library/systemd/
      Tasks: 0 (limit: 9337)
     Memory: 0B
        CPU: 0
     CGroup: /system.slice/mariadb.service

所以为什么还要给我

用法: /etc/init.d/mysql start\x\n\>重装\

我试着卸载每一个瘦，重新安装它，并用安全和更新我的系统安装-我使用了很多年基于debian的kali-linux，没有问题。

编辑

当我运行mysql状态时，我也会看到下面的日志。

ay 13 11:15:37 Dodge mariadbd[14041]: 2021-05-13 11:15:37 3 [Warning] Access denied for user 'roo…rd: NO)
May 13 11:15:37 Dodge mariadbd[14041]: 2021-05-13 11:15:37 4 [Warning] Access denied for user 'roo…rd: NO)
May 13 11:15:37 Dodge /etc/mysql/debian-start[14065]: /usr/bin/mysql_upgrade: the '--basedir' option…nored
May 13 11:15:37 Dodge /etc/mysql/debian-start[14065]: Looking for 'mysql' as: /usr/bin/mysql
May 13 11:15:37 Dodge /etc/mysql/debian-start[14065]: Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck
May 13 11:15:37 Dodge /etc/mysql/debian-start[14065]: Version check failed. Got the following error …lient
May 13 11:15:37 Dodge /etc/mysql/debian-start[14065]: ERROR 1045 (28000): Access denied for user 'ro…: NO)
May 13 11:15:37 Dodge /etc/mysql/debian-start[14065]: FATAL ERROR: Upgrade failed
May 13 11:15:37 Dodge mariadbd[14041]: 2021-05-13 11:15:37 5 [Warning] Access denied for user 'roo…rd: NO)
May 13 11:15:37 Dodge debian-start[14078]: ERROR 1045 (28000): Access denied for user 'root'@'local…d: NO)
Hint: Some lines were ellipsized, use -l to show in full.

Answer 1

which mysql返回/etc/init.d/mysql。这是因为/etc/init.d位于/usr/bin之前的路径中，它的效果是在键入mysql时执行/etc/init.d/mysql。

您需要确保mysql客户端的位置位于路径中的/etc/init.d之前。或者将/etc/init.d从路径中移除；我看不到它存在的任何原因。此外，要使此更改永久化，您需要更改配置文件或bashrc文件中路径的设置。

如果您有理由不更改路径变量，则需要通过提供完整的路径名：/usr/bin/mysql来启动mysql客户端。