If you have direct access to the remote server and aren't worried about security GRANT ALL PRIVILEGES ON MY_DATABASE_NAME.* TO IDENTIFIED BY 'MY_PASSWORD' To grant access for a remote connection, login to mysql using 'mysql -p -u root' and then create a new user to avoid using root: To allow connection on all interfaces set it to '0.0.0.0' The RPi default is 127.0.0.1 for localhost only. This is the local address(es) / network adaptors that MySQL will listen for connections on. Or the internal socket connection on '/var/run/mysqld/mysqld.sock'įind the configuration line called bind-address. Login to mysql using 'mysql -p -u root' and then create a new user to avoid using root:ĬREATE USER IDENTIFIED BY 'MY_PASSWORD' įor security reasons, by default access to the MySQL server via the main IP address is disabled in the MySQL config. You should now have a mysql> prompt.Įxiting MySQL connection / command line loginįist connect to the database using 'mysql -p -u root'. Then enter the users password when prompted. The php5-mysql install adds the mysql libraries to allow PHP to access the mysql database.įirst connect to the database and specify a user:
