Skip to main content

Easy way deploy and manage mysql database to linux server

Let assume that you have setup the linux server with mysql. Now you want to deploy the database to the server you have created on your developement enviroment. 

You development enviroment may be windows or mac or linux with the gui but server are run only cli.


So it is necessary to know the easy way to deploy database to the server with just cli



Importing the mysql database to mysql using the cli


1) Export the sql file of the database from your development enviroment.


2) Copy the sql file to the serve using the sftp.


3) Now import the sql file to you mysql using this comman snippet


    $ mysql -u [username] -p < [path/to/your/sql/file] 

    $ password : [your password ] [will be invisible on screen]
    $ 

After sucessfull import of sql file your database will ready to be used.


Note that if there is any error during the import than it will print the error on the screen but in case of successful import it will not generate any response.



Now to access the database deployed on the server you may use the phpmyadmin. But it come at the cost of php. Your production application might not using the phpmyadmin. 


To overcome this you can use another approch to access the remote mysql server using the mysql client.




Remote Mysql Connection


To enable the remote access for the mysql remote access you have to enable the remote access to the user run this command




GRANT ALL PRIVILEGES ON *.* TO '[username]'@'[host]' IDENTIFIED BY '[password]'
WITH GRANT OPTION;


Here [username] is the user name for which you want to enabel the remote access. and [host] is the host for which you want to enable the remote acess. 
[host] may be an ip address or the dns name of host.

After this step you can connect to the remote mysql server using your local mysql client

Mysql clients


For windows : mysql workbench
For Mac : sequelPro
For Linux  : mysql workbench

Comments

  1. Another easier way to deploy a PHP and MySQL website to a server is by using a platform like Cloudways web hosting for PHP. With this platform, users can launch a managed servers on cloud in just one click with PHP and MySQL already installed on it.

    ReplyDelete

Post a Comment

Popular posts from this blog

Google blogger Ideas panel

Google blogger Ideas  I opened by blogger today, and..   I got this.  Google blogger Ideas  A panel suggesting a topic on which I can write my next blog. It's fetching unanswered question from web according to your previous post and topics. It was something, I was really looking for, after all it takes time to finding subject on which to write next and still being in the same niche.  Awesome feature Blogger! 

Apache : setup basic auth with apache in windows

Authentication is any process by which you verify that someone is who they claim they are. Authorization is any process by which someone is allowed to be where they want to go or to have information that they want to have. I will show here how to set up basic auth on the apache with windows. Pre-requests  Windows VPS Apache server ( That's it ) ( In windows it might be difficult to setup the Apache alone. So instead use something ling xampp , wamp or laragon .) RestClient (  I personally use the postman , but you can use your preferable client)  Windows VPS provider Steps  Enable the necessary modules in the Apache Create the password file Set the auth directives in the virtual host file. Verify basic auth. Enable the  necessary   modules  in the Apache Open the httpd.conf file in the apache's conf folder. httpd.conf file Enable the necessary modules to make the basic auth working. Necessary modules  mod_auth_basic

Firebase - update a spacific fields of single element of object of array in firestore

Firebase - update a spacific fields of single element of object of array in firestore  Its actully advisable to use map instead of array when ever it is possible. But, there are cetain cases where you don't have option to do so.  For example, you are directly saving the response from some outer source without any modification and they send you an array. In this case you will have array to work with. Firestore does not support array here is why  "bad things can happen if you have multiple clients all trying to update or delete array elements at specific indexes. In the past, Cloud Firestore addressed these issues by limiting what you can do with arrays " For more details information you can refer to Kato Richardson post Best Practices: Arrays in Firebase .  Firestore document having array [ used from stackoverflow question ] Suppose you have array of object something like shown in array. Now you want to update endTime field of the object on the index [1]