[root@WKemp2 ~]# mysqld --defaults-file=/usr/local/etc/my.cnf --basedir=/usr/local/mysql8 --datadir=/data/mysql8_data/mysql1--user=mysql1 --initialize-insecure -bash: mysqld: command not found

这个错误提示意味着系统找不到 `mysqld` 命令。可能是 MySQL 没有正确安装或者系统环境变量没有正确设置。你可以尝试以下几个步骤解决问题：

1. 确认 MySQL 已经正确安装并且在系统中可以找到 `mysqld` 命令。
2. 检查系统环境变量是否正确设置，可以使用 `echo $PATH` 命令查看环境变量路径是否包含 MySQL 的安装路径。
3. 如果 MySQL 已经正确安装，但是系统无法找到 `mysqld` 命令，可以尝试使用完整路径启动 MySQL，例如 `/usr/local/mysql8/bin/mysqld`。

希望这些步骤可以帮助你解决问题。

相关问题

service mysql start /etc/init.d/mysql: line 239: my_print_defaults: command not found /etc/init.d/mysql: line 259: cd: /usr/local/mysql: No such file or directory Starting MySQL ERROR! Couldn't find MySQL server (/usr/local/mysql/bin/mysqld_safe)

这个错误通常是因为MySQL服务器未正确安装或未正确设置路径导致的。请按照以下步骤进行排查和解决：

1. 确保MySQL服务器已正确安装。您可以使用以下命令检查MySQL是否已安装：

   dpkg -l | grep mysql

如果MySQL未安装，您可以使用以下命令安装它：

   sudo apt-get update
   sudo apt-get install mysql-server

2. 检查MySQL配置文件中的路径设置。打开MySQL配置文件（通常是`/etc/mysql/my.cnf`）并找到`basedir`和`datadir`指令。确保这些路径与您的MySQL安装位置相匹配。例如，如果MySQL安装在`/usr/local/mysql`目录下，那么这些指令应该如下所示：

   basedir = /usr/local/mysql
   datadir = /usr/local/mysql/data

3. 如果MySQL安装位置与配置文件中的路径设置不匹配，您需要将配置文件中的路径设置更新为正确的路径。

4. 如果您已更改了MySQL的安装位置或配置文件中的路径设置，并且仍然遇到问题，可能需要重新安装MySQL。在重新安装之前，确保完全删除旧的MySQL安装。您可以使用以下命令来删除MySQL：

   sudo apt-get remove --purge mysql-server mysql-client mysql-common
   sudo apt-get autoremove
   sudo apt-get autoclean

之后，按照步骤1重新安装MySQL。

请注意，具体的解决方法可能因操作系统和MySQL版本而有所不同。如果上述方法无法解决问题，请提供更多详细信息，以便我能够更准确地帮助您解决问题。

ubuntu mysql8.0.32 /etc/mysql/my.cnf 文件内容

以下是在Ubuntu系统上安装MySQL 8.0.32后的默认 /etc/mysql/my.cnf 文件内容：

# The MySQL database server configuration file.
#
# You can copy this to one of:
# - "/etc/mysql/my.cnf" to set global options,
# - "~/.my.cnf" to set user-specific options.
# 
# One can use all long options that the program supports.
# Run program with --help to get a list of available options and with
# --print-defaults to see which it would actually understand and use.
#
# For explanations see
# http://dev.mysql.com/doc/mysql/en/server-system-variables.html

[mysqld]
#
# * Basic Settings
#
user                           = mysql
pid-file                       = /var/run/mysqld/mysqld.pid
socket                         = /var/run/mysqld/mysqld.sock
basedir                        = /usr
datadir                        = /var/lib/mysql
tmpdir                         = /tmp
lc-messages-dir                = /usr/share/mysql
#skip-external-locking
skip-name-resolve
skip-host-cache
skip-ssl
sql-mode                       = ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
log-error                      = /var/log/mysql/error.log

# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

# Recommended in standard MySQL setup
# sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

#
# * Character sets
#
# MySQL/MariaDB default is Latin1, but in Ubuntu UTF-8 is default
#
character-set-server  = utf8mb4
collation-server      = utf8mb4_general_ci

#
# * InnoDB
#
# InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/.
# Read the manual for more InnoDB related options. There are many!
#

#
# * Security Features
#
# Read the manual, too, if you want chroot!
# chroot = /var/lib/mysql/
#
# For generating SSL certificates you can use for example the GUI tool "tinyca".
#
# ssl-ca=/etc/mysql/cacert.pem
# ssl-cert=/etc/mysql/server-cert.pem
# ssl-key=/etc/mysql/server-key.pem

[mysql]
#
# * Basic Settings
#
socket                         = /var/run/mysqld/mysqld.sock
prompt                         = \u@\h [\d]>\_

[mysqldump]
#
# * Basic Settings
#
socket                         = /var/run/mysqld/mysqld.sock
quick
quote-names
max_allowed_packet             = 16M

[isamchk]
key_buffer                     = 16M

#
# * IMPORTANT: Additional settings that can override those from this file!
#   The files must end with '.cnf', otherwise they'll be ignored.
#
!includedir /etc/mysql/conf.d/

注意，这只是默认的配置文件，实际上你可以根据需要进行修改。