Note that this Wiki is a work in progress, items may not be updated or may disappear entirely as the pages are updated.

From SpacialAudio

Question:

I am setting up my samphpweb pages on a new server. What is the mysql command to grant access to the new server?

Answer:

From your SAM's mysql system go to a command prompt and type the following. <enter> means press the enter key;

c: <enter>
cd \mysql\bin <enter>
mysql --user=newusername --password=yourpassword mysql <enter>
GRANT ALL PRIVILEGES ON SAMDB.* TO newusername@myiporhostname IDENTIFIED BY 'yourpassword'; <enter>
quit <enter>

Your server should now have access to your mysql server.