mysql -bash: mysqladmin: 未找到命令

最新推荐文章于 2024-04-08 13:42:43 发布
原创 最新推荐文章于 2024-04-08 13:42:43 发布 · 2.7k 阅读 · 2 ·
CC 4.0 BY-SA版权
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
文章标签：

#linux #nginx #运维

问题
-bash: mysqladmin: 未找到命令
答案
ln -s /usr/local/mysql/bin/* /usr/local/bin

yunweiBOKE
关注
mysql问题处理（报错代码 -bash:mysql:command not found）
夫君子之行,静以修身,俭以养德,非淡泊无以明志,非宁静无以致远.
06-28 7395
问题为： [root@Neo777 bin]# mysql -u root -p -bash: mysql: command not found       #报错 原因:这是由于系统默认会查找（默认在/usr/bin下）的命令，如果这个命令不在这个目录下，当然会找不到命令， 我们需要做的就是映射一个链接到/usr/bin目录下，相当于建立一个链接文件。首先得知道mys
-bash: mysql: command not found的问题与解决
01-09
前几天重装了mysql，装好之后navicat一直正常可以对mysql进行操作，但是今天要使用命令行进行操作时遇到-bash: mysql: command not found的问题。 总结一下解决办法： 这个问题的出现是两个原因 1 .bash_profile中path路径不正确，这里面的路径是你当前登录的用户去执行mysql的路径，你可以直接把这个path设置为mysql安装的位置，如：/usr/local/mysql-5.7.17-macos10.12-x86_64/bin。 2.第二个原因是可能在安装mysql的时候默认将mysql的执行路径设置为/usr/local/bin或/us
-bash: mysqladmin: command not found
qq1139991268的博客
03-16 3961
之前安装mysql位置忘记了 1、找到mysql安装路径 方法：进入mysql命令行输入：show variables like “%char%”; Variable_name Value character_sets_dir /usr/local/mysql/share/charsets/ 上面这个 /usr/local/mysql 就是mysql安装路...
mysql mysqladmin: command not found解决方法
weixin_33695082的博客
01-02 528
mysql mysqladmin: command not found解决方法有时候安装好MySQL程序的时候，直接输入命令mysql或mysqladmin会发现提示命令不存在，这是由于系统默认会查找/usr/bin下的命令，如果这个命令不在这个目录下，当然会找不到命令，我们需要做的就是映射一个链接到/usr/bin目录下，相当于建立一个链接文件。首先得知道mysql命令或m...
MySQL装好了但是找不到命令-bash: mysqladmin: command not found：建立软连接
思维小刀
05-24 3188
[root@localhost support-files]# service mysqld status SUCCESS! MySQL running (68596) #mysqladmin [root@localhost support-files]# mysqladmin -uroot password 123456 -bash: mysqladmin: command not found [root@localhost support-files]# ln -s /usr/local/mys.
bash: mysql: 未找到命令...
个人记录
09-24 235
原因：未配置环境变量 vi ~/.bash_profile 在文件最后面加入以下内容 export PATH=$PATH:/usr/local/mysql/bin 使生效 source ~/.bash_profile
以下是我的mysql的yaml文件代码，请你根据这个写出Redis的yaml文件： # 创建命名空间 apiVersion: v1 kind: Namespace metadata: name: mysql-server --- # 主库PV - 部署到k8smaster apiVersion: v1 kind: PersistentVolume metadata: name: mysql-master-pv labels: app: mysql role: master spec: capacity: storage: 10Gi volumeMode: Filesystem accessModes: - ReadWriteOnce persistentVolumeReclaimPolicy: Retain local: path: /root/mysql_k8s/mysql-master nodeAffinity: required: nodeSelectorTerms: - matchExpressions: - key: kubernetes.io/hostname operator: In values: - k8smaster --- # 从库1 PV - 部署到k8snode1 apiVersion: v1 kind: PersistentVolume metadata: name: mysql-slave1-pv labels: app: mysql role: slave spec: capacity: storage: 10Gi volumeMode: Filesystem accessModes: - ReadWriteOnce persistentVolumeReclaimPolicy: Retain local: path: /root/mysql_k8s/mysql-slave1 nodeAffinity: required: nodeSelectorTerms: - matchExpressions: - key: kubernetes.io/hostname operator: In values: - k8snode1 --- # 从库2 PV - 部署到k8snode2 apiVersion: v1 kind: PersistentVolume metadata: name: mysql-slave2-pv labels: app: mysql role: slave spec: capacity: storage: 10Gi volumeMode: Filesystem accessModes: - ReadWriteOnce persistentVolumeReclaimPolicy: Retain local: path: /root/mysql_k8s/mysql-slave2 nodeAffinity: required: nodeSelectorTerms: - matchExpressions: - key: kubernetes.io/hostname operator: In values: - k8snode2 --- # 主库PVC apiVersion: v1 kind: PersistentVolumeClaim metadata: name: mysql-master-pvc namespace: mysql-server spec: accessModes: - ReadWriteOnce resources: requests: storage: 10Gi selector: matchLabels: app: mysql role: master --- # 从库1 PVC apiVersion: v1 kind: PersistentVolumeClaim metadata: name: mysql-slave1-pvc namespace: mysql-server spec: accessModes: - ReadWriteOnce resources: requests: storage: 10Gi selector: matchLabels: app: mysql role: slave --- # 从库2 PVC apiVersion: v1 kind: PersistentVolumeClaim metadata: name: mysql-slave2-pvc namespace: mysql-server spec: accessModes: - ReadWriteOnce resources: requests: storage: 10Gi selector: matchLabels: app: mysql role: slave --- # 配置文件 apiVersion: v1 kind: ConfigMap metadata: name: mysql-config namespace: mysql-server data: my_master.conf: |- [mysqld] server_id=1 log-bin=mysql-bin binlog-ignore-db=mysql binlog-ignore-db=information_schema binlog-do-db=test binlog_format=ROW expire_logs_days=7 max_binlog_size=100M symbolic-links=0 sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES my_slave1.conf: |- [mysqld] server_id=2 relay-log=relay-bin log-bin=mysql-slave1-bin read_only=1 log_slave_updates=1 slave-skip-errors=1032,1062,1007,1050 symbolic-links=0 my_slave2.conf: |- [mysqld] server_id=3 relay-log=relay-bin log-bin=mysql-slave2-bin read_only=1 log_slave_updates=1 slave-skip-errors=1032,1062,1007,1050 symbolic-links=0 --- # 主库Service apiVersion: v1 kind: Service metadata: name: mysql-master namespace: mysql-server spec: selector: app: mysql mysql: master ports: - port: 3306 targetPort: 3306 clusterIP: None --- # 从库Service apiVersion: v1 kind: Service metadata: name: mysql-slaves namespace: mysql-server spec: selector: app: mysql mysql: slave ports: - port: 3306 targetPort: 3306 clusterIP: None --- # 主库Deployment apiVersion: apps/v1 kind: Deployment metadata: name: mysql-master namespace: mysql-server spec: replicas: 1 selector: matchLabels: app: mysql mysql: master template: metadata: labels: app: mysql mysql: master spec: tolerations: - key: "node-role.kubernetes.io/master" operator: "Exists" effect: "NoSchedule" nodeSelector: kubernetes.io/hostname: k8smaster containers: - name: mysql-master image: mysql:5.7 ports: - containerPort: 3306 name: mysql-port env: - name: MYSQL_ROOT_PASSWORD value: root - name: MYSQL_DATABASE value: test # 主库自动创建test数据库 volumeMounts: - name: mysql-master-storage mountPath: /var/lib/mysql - name: mysql-config mountPath: /etc/mysql/conf.d/my.cnf subPath: my.cnf livenessProbe: exec: command: ["mysqladmin", "ping", "-uroot", "-proot"] initialDelaySeconds: 30 periodSeconds: 10 readinessProbe: exec: command: ["mysqladmin", "ping", "-uroot", "-proot"] initialDelaySeconds: 5 periodSeconds: 5 volumes: - name: mysql-master-storage persistentVolumeClaim: claimName: mysql-master-pvc - name: mysql-config configMap: name: mysql-config items: - key: my_master.conf path: my.cnf --- # 从库1 Deployment apiVersion: apps/v1 kind: Deployment metadata: name: mysql-slave1 namespace: mysql-server spec: replicas: 1 selector: matchLabels: app: mysql mysql: slave slave-id: "1" template: metadata: labels: app: mysql mysql: slave slave-id: "1" spec: nodeSelector: kubernetes.io/hostname: k8snode1 containers: - name: mysql-slave1 image: mysql:5.7 ports: - containerPort: 3306 name: mysql-port env: - name: MYSQL_ROOT_PASSWORD value: root - name: MASTER_HOST value: mysql-master - name: MASTER_USER value: repl - name: MASTER_PASSWORD value: replpass volumeMounts: - name: mysql-slave-storage mountPath: /var/lib/mysql - name: mysql-slave-config mountPath: /etc/mysql/conf.d/my.cnf subPath: my.cnf - name: init-scripts mountPath: /docker-entrypoint-initdb.d livenessProbe: exec: command: ["mysqladmin", "ping", "-uroot", "-proot"] initialDelaySeconds: 30 periodSeconds: 10 readinessProbe: exec: command: ["mysqladmin", "ping", "-uroot", "-proot"] initialDelaySeconds: 5 periodSeconds: 5 volumes: - name: mysql-slave-storage persistentVolumeClaim: claimName: mysql-slave1-pvc - name: mysql-slave-config configMap: name: mysql-config items: - key: my_slave1.conf path: my.cnf - name: init-scripts configMap: name: slave-init-scripts --- # 从库2 Deployment apiVersion: apps/v1 kind: Deployment metadata: name: mysql-slave2 namespace: mysql-server spec: replicas: 1 selector: matchLabels: app: mysql mysql: slave slave-id: "2" template: metadata: labels: app: mysql mysql: slave slave-id: "2" spec: nodeSelector: kubernetes.io/hostname: k8snode2 containers: - name: mysql-slave2 image: mysql:5.7 ports: - containerPort: 3306 name: mysql-port env: - name: MYSQL_ROOT_PASSWORD value: root - name: MASTER_HOST value: mysql-master - name: MASTER_USER value: repl - name: MASTER_PASSWORD value: replpass volumeMounts: - name: mysql-slave-storage mountPath: /var/lib/mysql - name: mysql-slave-config mountPath: /etc/mysql/conf.d/my.cnf subPath: my.cnf - name: init-scripts mountPath: /docker-entrypoint-initdb.d livenessProbe: exec: command: ["mysqladmin", "ping", "-uroot", "-proot"] initialDelaySeconds: 30 periodSeconds: 10 readinessProbe: exec: command: ["mysqladmin", "ping", "-uroot", "-proot"] initialDelaySeconds: 5 periodSeconds: 5 volumes: - name: mysql-slave-storage persistentVolumeClaim: claimName: mysql-slave2-pvc - name: mysql-slave-config configMap: name: mysql-config items: - key: my_slave2.conf path: my.cnf - name: init-scripts configMap: name: slave-init-scripts --- # 从库初始化脚本（已包含创建test数据库的步骤） apiVersion: v1 kind: ConfigMap metadata: name: slave-init-scripts namespace: mysql-server data: init-slave.sh: |- #!/bin/bash set -e # 等待主库就绪 until mysql -h$MASTER_HOST -uroot -p$MYSQL_ROOT_PASSWORD -e "SELECT 1"; do echo "等待主库就绪..." sleep 5 done # 关键步骤：在从库创建test数据库，与主库保持一致 mysql -uroot -p$MYSQL_ROOT_PASSWORD -e "CREATE DATABASE IF NOT EXISTS test;" # 在主库创建复制用户 mysql -h$MASTER_HOST -uroot -p$MYSQL_ROOT_PASSWORD -e "CREATE USER IF NOT EXISTS '$MASTER_USER'@'%' IDENTIFIED BY '$MASTER_PASSWORD'; GRANT REPLICATION SLAVE ON *.* TO '$MASTER_USER'@'%'; FLUSH PRIVILEGES;" # 获取主库日志位置 MASTER_STATUS=$(mysql -h$MASTER_HOST -uroot -p$MYSQL_ROOT_PASSWORD -e "SHOW MASTER STATUS\G" | grep -E 'File|Position') MASTER_LOG_FILE=$(echo "$MASTER_STATUS" | grep File | awk '{print $2}') MASTER_LOG_POS=$(echo "$MASTER_STATUS" | grep Position | awk '{print $2}') # 配置从库复制 mysql -uroot -p$MYSQL_ROOT_PASSWORD -e "CHANGE MASTER TO MASTER_HOST='$MASTER_HOST', MASTER_USER='$MASTER_USER', MASTER_PASSWORD='$MASTER_PASSWORD', MASTER_LOG_FILE='$MASTER_LOG_FILE', MASTER_LOG_POS=$MASTER_LOG_POS; START SLAVE;" # 检查复制状态 mysql -uroot -p$MYSQL_ROOT_PASSWORD -e "SHOW SLAVE STATUS\G"
最新发布
10-15
以下是参考 MySQL 的 YAML 文件结构生成的 Redis 的 Kubernetes YAML 文件示例，包含命名空间、PV、PVC、ConfigMap、Service 和 Deployment 等资源： ```yaml # 创建命名空间 apiVersion: v1 kind: Namespace ...
解决bash: mysql: command not found 的方法
09-10
在Linux环境中，当你尝试在命令行中运行`mysql`命令时，如果遇到`bash: mysql: command not found`的错误提示，这通常意味着系统无法在默认的可执行文件搜索路径中找到`mysql`客户端。这个错误通常发生在你安装了...
详解：-bash: mysql command not found （mysql未找到命令）
Mutsa的博客
02-28 1万+
解决：-bash: mysql command not found （mysql未找到命令）
解决：-bash: mysql: 未找到命令 这一问题
热门推荐
weixin_45111980的博客
08-09 2万+
故障 昨天使用的MySQL之后，由于公司突然停电 今天重新开机发现mysql命令无法使用。 排查思路： 1.查看MySQL服务是否启动 · netstat -lnp|grep mysql 发现MySQL已经在运行中 说明问题不在这。 2.查看当前命令的使用路径： 已知mysql命令的二进制执行文件在 /usr/local/mysql/bin/ 下， 查看当前命令的路径：echo $PATH...
解决Linux：-bash: mysql: 未找到命令 问题
qq_61407171的博客
03-09 9231
解决 Failed to search for file: cannot update repo ‘appstream’: Cannot prepare internal mirrorlist: No URLs in mirrorlist。因为Centos 8已经停止维护，所以需要改变镜像。4、在/etc/profile配置系统环境变量。5、让profile文件立即生效。1、查看MySQL服务是否启动。2、查看MySQL运行环境。3、暂停MySQL服务。
mysql mysqladmin: command not found
y368769的博客
01-08 790
解决方案： ln -s /usr/local/mysql/bin/mysqladmin /usr/bin/mysqladmin 原因是此命令没有在系统默认的默认目录下 说明：/usr/local/mysql/bin/mysqladmin 是mysql安装目录得bin/mysqladmin ...
mysql: command not found 找不到mysql命令
hyy
07-15 1万+
bash: mysql: command not foundmysql找不到命令linux输入mysql没有启动1.命令都是保存在/usr/bin下，找不到命令一定是没有在bin下创建链接可以通过ls查看bin下的所有命令 2.下一步找到mysql的命令的位置 3.创建链接：我的是在这个目录下/usr/local/mysql/bin/mysql 4.再次启动mysql 出现这样的结果就是成功了......
-bash: mysql: command not found
wufaqidong1的博客
01-11 9201
原因：这是由于系统默认会查找的/ usr / bin中下的命令，如果这个命令不在这个目录下，当然会找不到命令，我们需要做的就是映射一个链接到的/ usr /仓目录下，相当于建立一个链接文件。错误： bash：mysql：找不到命令。
linux安装完mysql出现-bash: mysql: 未找到命令
疯癫的老码农的博客
09-25 3024
linux安装完mysql出现-bash: mysql: 未找到命令。可能原因是：缺少环境变量。
-bash:mysql：command not found 详解
weixin_44767199的博客
04-08 1855
-bash:mysql：command not found
评论 1
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
红包 添加红包
表情包 插入表情
表情包 代码片
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值