#UNABLE TO CONNECT TO LOCALHOST MYSQL WORKBENCH PASSWORD#

GRANT ALL PRIVILEGES ON databasename.* TO don't understand why u used '***' as your password so I replaced it with 'password'. Then do your original commands again: CREATE USER IDENTIFIED BY 'password' So do these commands: DROP User User if you see user, also drop/delete that row. It looks like you're trying to make a new user by the name of but a different user by the name of is getting in the way/taking precedence.ĭo this command to see the users: SELECT user,host FROM er IPv4= 192.168.11.1Ĭomputer B= Has an Eclipse program that wants to connect to Computer A and do stuff to the schemas. What am I missing? Have I forgotten to do something or what else can I check?Ĭomputer A = Holds the MySQL DB.

I have some other remote accounts on the same server and none of them have as they only connect locally. I have done 'flush privileges' but I still cannot connect - I notice that the error is and I don't have any permissions set up for but I have never had to do this before. On the remote server I then use: mysql -u username -p DB_SERVER_IPĪnd get the error message: ERROR 1045 (28000): Access denied for user (using password: YES) | GRANT ALL PRIVILEGES ON `databasename`.* TO rows in set (0.00 sec) | Grants for GRANT USAGE ON *.* TO IDENTIFIED BY PASSWORD '***' Then I gave permissions: GRANT ALL PRIVILEGES ON databasename.* to user table on MySQL server shows (amongst other things): +-+-+ I added the user by: CREATE USER IDENTIFIED BY '***' You can start querying the database now.I am setting up a remote connection to a MySQL server but no matter what I try I am getting access denied error from the remote server. You have connected to the server and selected the database you want to work with. Thus it is a good practice to close the MySQL connection once all the queries are executed. And too many open MySQL connections can cause problems for your account. Your script will still run if you do not include this function. This is a very important function as it closes the connection to the database server. If the script cannot connect it will stop executing and will show the error message “Unable to select database”.Īnother important PHP function is: $mysqli->close() With the above PHP uses the MySQL connection and with it – selects the database stored in the variable $database (in our case it will select the database “your_database”). To select a database, you can use the following command: $mysqli->select_db($database) or die( 'Unable to select database') This should be a database to which your username has access to. With this line PHP connects to the MySQL database server at localhost with the provided username and password.Īfter the connection is established you should select the database you wish to use.

This can be done with the mysql_connect PHP function: $mysqli = new mysqli('localhost', $username, $password, $database) Next you should connect your PHP script to the database. This will create three variables in PHP that will store the different MySQL connection details. You should replace your_username, your_password and your_database with the MySQL username, password and database that will be used by your script. If you need to change them later, this way you will be able to perform the change easily. Connecting to a database via PHP is an extremely important step because if your script cannot connect to its database, your queries to the database will fail.Ī good practice when using databases is to set the username, the password and the database name values at the beginning of the script code.

Unable to connect to localhost mysql workbench