mardi 8 octobre 2019

How to create a mysql user to access a remote database from anywhere in the world?

I logged into my VM mysql,

I created this new user

CREATE USER 'someUser'@'%' IDENTIFIED BY 'somePass';
FLUSH PRIVILEGES;
select User,Host from mysql.user;

+------------------+--------------------------------------+
| User             | Host                                 |
+------------------+--------------------------------------+
| someUser         | %                                    |

Update my .env

DB_CONNECTION=mysql
DB_HOST=someHost
DB_DATABASE=bhengDev
DB_USERNAME=someUser
DB_PASSWORD=somePass
DB_PORT=3306

Then when I load the site, I keep getting

SQLSTATE[HY000] [1044] Access denied for user 'someUser'@'%' to database 'bhengDev'

Do I need to do anything else?

I need to allow remote access into my database from anywhere.

Is this a mysql issue or a Laravel issue ?



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire