Hi! I’ve been developing a website with a MySQL database locally. This week I will have to put it online. Since it’s the first time that I do this, can you tell me everything I have to pay attention to?
For example, how should I change this line of code?
You will need to change that to match the database details of your live webserver, the easiest way to export and upload a database is to use the mysql_dump program to generate yourself a .sql file, upload this via FTP and use the command line mysql client to import it (\. file.sql)
A normal user you would limit to only the databases that user should be able to work with. It gives you the power to separate site A from site B so there is no way data can be accessed by the wrong system / user.