Mysql connection error 1130

I have a project on the server, know the server address, and know the mysql account and password. But when I was connected, I reported an error and found related information on the Internet. I am not familiar with linux, after logging on to the server, running mysql in the Command always reports an error-bash: commondnotfound, I have cd to m...

There is a project on the server that knows the server address and mysql account password, but an error is reported during connection.

I have searched relevant information on the Internet. I am not familiar with linux. When I log on to the server and run mysql in a command, I always report an error-bash: commond not found, I have already cd to the bin directory under the mysql installation directory. This error will still be reported. This is still an integrated phpstudy environment. I feel that the files in the installation directory are a little different. The files are directly in the bin, and there is no folder named in the php version, which is annoying. How can this problem be solved? Urgent!

Reply content:

There is a project on the server that knows the server address and mysql account password, but an error is reported during connection.

I have searched relevant information on the Internet. I am not familiar with linux. When I log on to the server and run mysql in a command, I always report an error-bash: commond not found, I have already cd to the bin directory under the mysql installation directory. This error will still be reported. This is still an integrated phpstudy environment. I feel that the files in the installation directory are a little different. The files are directly in the bin, and there is no folder named in the php version, which is annoying. How can this problem be solved? Urgent!

If your client IP address changes frequently, create a host name%Represents the address of any client host.

create user 'username'@'%' identified by 'password'; 

Grant all permissions to all databases'username'@'%'

grant all privileges on *.* to 'username'@'%';

Mysql on the server does not support public network access. For details, you can use Baidu mysql for remote connection.

It may be a permission issue!

When I run mysql in a command after I log on to the server, the following error always occurs: bash: commond not found.
You can add the bin directory of mysql to the/etc/profile file.

vim /etc/profilePATH=$PATH:/usr/local/mysql/bin export PATHsource /etc/profile