\n \n<\/p>\n
\nIf you want MySQL also do the following:\n<\/p>\n
\r\n\r\nsudo apt-get install mysql-server\r\nsudo apt-get install php5-mysql\r\n<\/code><\/pre>\n\nThe php5-mysql install adds the mysql libraries to allow PHP to access the mysql database.\n<\/p>\n
\nAccessing MySQL from the command line
\n<\/h4>\n
\nFirst connect to the database and specify a user:\n<\/p>\n
\r\n\r\nmysql -p -u root\r\n<\/code><\/pre>\n\nThen enter the users password when prompted. You should now have a mysql> prompt. \n<\/p>\n
\nExiting MySQL connection \/ command line login
\n<\/h5>\n\r\n\r\nquit\r\n<\/code><\/pre>\n\nRestarting The MySQL service
\n<\/h4>\n\r\n\r\nsudo service mysql restart\r\n<\/code><\/pre>\n\n \n<\/p>\n
\nCreating A Database
\n<\/h4>\n
\nFist connect to the database using "mysql -p -u root". To create a database:\n<\/p>\n
\r\n\r\nCREATE DATABASE MY_DATABASE_NAME;\r\n<\/code><\/pre>\n\nAdding A User
\n<\/h4>\n
\nLogin to mysql using "mysql -p -u root" and then create a new user to avoid using root:\n<\/p>\n
\r\n\r\nCREATE USER 'MY_USERNAME'@'localhost' IDENTIFIED BY 'MY_PASSWORD';\r\n<\/code><\/pre>\n\nAccessing a database
\n<\/h4>\n\nLocal Access
\n<\/h5>\n
\nFor security reasons, by default access to the MySQL server via the main IP address is disabled in the MySQL config. You can connect locally using:\n<\/p>\n
\nlocalhost
\n127.0.0.1
\nor the internal socket connection on "\/var\/run\/mysqld\/mysqld.sock"\n<\/p>\n
\nRemote Access
\n<\/h5>\n
\nFirst we need to edit the MySQL config:\n<\/p>\n
\r\n\r\nsudo nano \/etc\/mysql\/my.cnf\r\n<\/code><\/pre>\n\nFind the configuration line called bind-address. By default this is set to 127.0.0.1. \n<\/p>\n
\nThis is the local address(es) \/ network adaptors that MySQL will listen for connections on. The RPi default is 127.0.0.1 for localhost only. To allow connection on all interfaces set it to "0.0.0.0"\n<\/p>\n
\nSet it to "0.0.0.0" and save the file\n<\/p>\n
\r\n\r\nsudo service mysql restart\r\n<\/code><\/pre>\n\n \n<\/p>\n
\nTo grant access for a remote connection, login to mysql using "mysql -p -u root" and then create a new user to avoid using root:\n<\/p>\n
\r\n\r\nCREATE USER 'MY_USERNAME'@'localhost' IDENTIFIED BY 'MY_PASSWORD';\r\n<\/code><\/pre>\n\nTo allow access from any IP address\n<\/p>\n
\r\n\r\nGRANT ALL PRIVILEGES ON MY_DATABASE_NAME.* TO 'MY_USERNAME'@'%' IDENTIFIED BY 'MY_PASSWORD';\r\nflush privileges;\r\n<\/code><\/pre>\n\nTo allow access from a fixed IP address\n<\/p>\n
\r\n\r\nGRANT ALL PRIVILEGES ON MY_DATABASE_NAME.* TO 'MY_USERNAME'@'12.34.56.78' IDENTIFIED BY 'MY_PASSWORD';\r\nflush privileges;\r\n<\/code><\/pre>\n\n \n<\/p>\n
\nChanging MySQL root User Password
\n<\/h4>\n