mysql -u exampleusername -pĭid you like this article? Do you have anything to add? Let’s discuss it in the comments below. Make sure to use the MySQL password you setup for it. Then after exiting, you can log back into MySQL with your new username. You can modify the username and password however you like. This command will set up the swap space on the ubuntu server. Also, I am assuming that you have already created called exampledotcomdatabase. To solve this we will enable the swap on your ubuntu 14.04 server. I am going to assume we will choose a username exampleusername and have its password be abcdefg12345. Then once you are logged in, you will create a new username with the following steps. Make sure to use the password for root that you setup with your mySQL installation. mysql -u exampleusername -p How To Create A New Username In Ubuntu 14.04 Then after exiting, you can log back into mysql with your new username. GRANT ALL PRIVILEGES ON exampledotcomdatabase. You can modify the username and password however you like.ĬREATE USER IDENTIFIED BY 'abcdefg12345' If you haven’t already created a database, you can learn how to how to create a new database in MySQL here. Also, I am assuming that you have already created called exampledotcomdatabase. Then use the following steps to create a new username in Ubuntu 18.04/16.04.įor the above command, make sure to use your password for your account in Ubuntu, not password that you setup for root in MySQL (assuming they are different).
0 Comments
Leave a Reply. |