There are a lot of development tools you can use on Ubuntu<\/a>, and one of them is MySQL. We’re sure you’re familiar with it, but MySQL is one of the most popular relational database management systems. It’s open source, and it sits behind other products like Oracle Database, which means MySQL also works on Ubuntu. To install it, you’ll just need to run a few commands in the terminal. We’re here to guide you through the process.<\/p>\n Like with many other development and technical tasks on Linux, there’s something to keep in mind before you install MySQL on Ubuntu. You’ll need an account with administrative (sudo) privileges to access the terminal. You’ll also need a network connection. Once you pass these prerequisites, you can proceed with the steps below. Oh, and after every command, you’ll have to press the Enter <\/strong>key.<\/p>\n <\/p>\n Or, simply start MySQL with <\/p>\n <\/p>\n MySQL will be installed on your machine. It could take a while, depending on your internet speed. When complete, you can check for it with the command mysql –version.<\/strong> At any time, you can check to see if MySQL is running by entering the command:<\/p>\n <\/p>\n <\/p>\n <\/p>\n <\/p>\n Those were just the basic steps for setting up MySQL on Ubuntu. After installation, there are a few other things we suggest doing.<\/p>\n <\/p>\n By default, you won’t get a password, but you can type the command:<\/p>\n <\/p>\n <\/p>\n From there, you can enter your password, press Y <\/strong>to confirm, follow the steps on your screen, and choose a password level.<\/p>\n <\/p>\n You can enable remote access to connect to your databases from another machine. Type the following commands:<\/p>\n <\/p>\n <\/p>\n <\/p>\n If you always want your server to run each time you reboot your system, run the command:<\/p>\n <\/p>\n <\/p>\n To see all users on a database, type the following command:<\/p>\n <\/p>\n <\/p>\n We hope you found this guide helpful. If you’re a developer using Ubuntu, you might also be interested in checking out our list of some of the best laptops<\/a> and desktops<\/a>, including ones that work well with Linux<\/a>. Having the right hardware can always make your life easier. <\/p>\n <\/p>\n <\/div>\n There are a lot of development tools you can use on Ubuntu, and one of them is MySQL. We’re sure you’re familiar with it, but MySQL is one of the most popular relational database management systems. It’s open source, and it sits behind other products like Oracle Database, which means MySQL also works on Ubuntu.… Continue reading How to install MySQL on Ubuntu<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":10565,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-11218","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-uncategorized","entry"],"_links":{"self":[{"href":"https:\/\/gsmkingpin.com\/wp\/wp-json\/wp\/v2\/posts\/11218","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/gsmkingpin.com\/wp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/gsmkingpin.com\/wp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/gsmkingpin.com\/wp\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/gsmkingpin.com\/wp\/wp-json\/wp\/v2\/comments?post=11218"}],"version-history":[{"count":0,"href":"https:\/\/gsmkingpin.com\/wp\/wp-json\/wp\/v2\/posts\/11218\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/gsmkingpin.com\/wp\/wp-json\/wp\/v2\/media\/10565"}],"wp:attachment":[{"href":"https:\/\/gsmkingpin.com\/wp\/wp-json\/wp\/v2\/media?parent=11218"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/gsmkingpin.com\/wp\/wp-json\/wp\/v2\/categories?post=11218"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/gsmkingpin.com\/wp\/wp-json\/wp\/v2\/tags?post=11218"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\n
\n<\/p>\n How to install MySQL on Ubuntu <\/h2>\n
\n
sudo apt update<\/strong><\/pre>\n<\/li>\n
![\"Installing](\"https:\/\/static1.xdaimages.com\/wordpress\/wp-content\/uploads\/wm\/2023\/10\/screenshot-from-2023-10-23-11-51-02.png\"\/)
<\/picture> <\/figure>\n<\/p><\/div>\n<\/p><\/div>\n<\/li>\nsudo apt upgrade<\/strong><\/pre>\n<\/li>\n
sudo apt install mysql-server<\/strong><\/pre>\n
![\"installing](\"https:\/\/static1.xdaimages.com\/wordpress\/wp-content\/uploads\/wm\/2023\/10\/screenshot-from-2023-10-25-11-57-08.png\"\/)
<\/picture> <\/figure>\n<\/p><\/div>\n<\/p><\/div>\n<\/li>\nsudo mysql -u root<\/strong><\/pre>\n
sudo systemctl start mysql.<\/strong><\/pre>\n<\/li>\n<\/ol>\n
sudo systemctl status MySQL<\/strong><\/pre>\n
\n\n<\/pre>\n
Additional steps for MySQL configuration <\/h2>\n
Secure your MySQL session<\/h3>\n
sudo mysql_secure_installation<\/strong><\/pre>\n
Allow remote access<\/h3>\n
sudo ufw enable\n\n<\/strong>sudo ufw allow mysql<\/strong><\/pre>\n
![\"Allowing](\"https:\/\/static1.xdaimages.com\/wordpress\/wp-content\/uploads\/wm\/2023\/10\/screenshot-from-2023-10-30-14-30-15.png\"\/)
<\/picture> <\/figure>\n<\/p><\/div>\n<\/p><\/div>\nLaunch MySQL at reboot<\/h3>\n
sudo systemctl enable mysql<\/strong><\/pre>\n
See users<\/h3>\n
SELECT User, Host, authentication_string FROM mysql.user;<\/strong><\/pre>\n
\n
Source link <\/a><\/p>\n","protected":false},"excerpt":{"rendered":"