![]() To shut down the MySQL server, run the following command: mysqladmin -u root -pnew-password shutdown 4 – Create and Delete Database | 6 | root | localhost | | Query | 0 | starting | show processlist | | Id | User | Host | db | Command | Time | State | Info | ![]() You should see the following output: mysqladmin: Using a password on the command line interface can be insecure. To check all the running processes of the MySQL service, run the following command: mysqladmin -u root -pnew-password processlist Type '\c' to clear the current input statement. ![]() Other names may be trademarks of their respective Oracle is a registered trademark of Oracle Corporation and/or itsĪffiliates. You should get the following output: Welcome to the MySQL monitor. Now, you can connect your MySQL server without specifying a username and password as shown below: mysql Save and close the file then change the ownership of the file to mysql: chown mysql:mysql ~/.my.cnf To do so, create a ~/.my.cnf file in your home directory: nano ~/.my.cnfĪdd the following information containing your MySQL host, username, and password: If this is your routine process, then you can save your lots of time by specifying your MySQL username and password in ~/.my.cnf file to automate the login process. In order to connect the MySQL server, you will be required to authenticate by specifying a username and password. apt-get update -y 1 – Automate the MySQL Login Once you are logged into your Ubuntu 18.04 server, run the following command to update your base system with the latest available packages. Connect to your Cloud Server via SSH and log in using the credentials highlighted at the top of the page. Create a new server, choosing Ubuntu 18.04 as the operating system with at least 1GB RAM.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |