There is a project on the server, know the server address, but also know the MySQL account password, but when the connection error
Online has searched the relevant information, the pit father is I do not understand to the Linux, boarded the server after the command to run MySQL always error-bash:commond not found, I have CD to MySQL installation directory under the Bin directory, or will report this error. This is also a phpstudy integration environment, feel that the files in the installation directory are a bit different, the bin is directly under the file, there is no PHP version of the file name folder, good annoying. How can this be solved? Urgent and urgent!
Reply content:
There is a project on the server, know the server address, but also know the MySQL account password, but when the connection error
Online has searched the relevant information, the pit father is I do not understand to the Linux, boarded the server after the command to run MySQL always error-bash:commond not found, I have CD to MySQL installation directory under the Bin directory, or will report this error. This is also a phpstudy integration environment, feel that the files in the installation directory are a bit different, the bin is directly under the file, there is no PHP version of the file name folder, good annoying. How can this be solved? Urgent and urgent!
If your client IP is constantly changing, create a host named %
user that represents any client host address.
Grant all permissions to all databases to the'username'@'%'
grant all privileges on *.* to 'username'@'%';
MySQL on the server does not open for public access support, the specific can be Baidu MySQL remote connection
May be a permissions issue!
Running MySQL under command after boarding the server is always an error-bash:commond not found
You can add this system variable to the/etc/profile file in the MySQL bin directory.
vim /etc/profilePATH=$PATH:/usr/local/mysql/bin export PATHsource /etc/profile