You can install mysql-server without apache and php by the way if you dont want a lamp setup. We have setup a lamp environment on 5.5.5.5 and everything is ready to go. ” Consider (5.5.5.5) is our mysql-server and is hosted on a VPS machine. So what does that mean ? Before going deep let me put up an example mysql-server. One thing you must understand is that mysql server only allow localhost connections by default. $ mysql -h -u root -pĮRROR 1130: Host '200.200.200.200' is not allowed to connect to this MySQL server When you try connecting to mysql-server() from a client machine(eg: 200.200.200.200) located elsewhere, this is the error you will see. xampp or wamp are great environments to connect to your server database from your computer and test your work before it is uploaded on a server. If you have shared hosting then it can act as a mysql client to connect to server database but cannot be used as a mysql server as it lacks root privileges of the system. You can access a mysql-server from your local computer(using xampp,wamp) or from another remote client( vps or dedi server with mysql-client installed). If you have a Lamp server running on your vps or dedicated server then it includes mysql-server. Mysql servers can be accessed by programming languages like php,perl,python,java to display the content in a fashioned way at the userend as well store data entered by users(eg: registration) in databases. Mysql is one of the available programs which lets you store and retrieve data efficiently. What is a database and mysql ?ĭatabases are collections of data.
0 Comments
Leave a Reply. |