Cara Menginstall MySQL pada Ubuntu
Ya, dulu sebelum-sebelumnya, aku ngandelin XAMPP untuk soal kekgini. Karena apa, enggak ribet. But, wait soon! Itu ribet guys! Bayangin, tiap mau jalanin server lokal harus ngaktifin dulu dari Xampp Control Panel.
But, yesterday was a history. Oke, seberapa ribet sih nginstall MySQL kalo OS kamu Linux, btw, punyaku U-Mate. Iam not using Arch Flavor, or something else, so, this thing for debian user. I dont know if Fedora has a similiar package deal, Let's start by typing simple command on your SexyCLI
$ sudo apt install mysql-server
Command above should take you to MySQL installation process. Wait for a while, and make sure that you has internet connected with!
When it's done, continue by secure installation,
$ sudo mysql_secure_installation
and you will be prompted with a few question! Just answer it, that's not midterm test in your fu*ki'n mid school!
and then create user to access database ( it's an optional ). Login as root to your mysql server
$ sudo mysql
mysql > create 'username'@'localhost' identified by 'yourpassword';
fyi. i prefer to use localhost and then change yourpassword with the password you want. Remeber, it depends on the questions you answered before, when mysql prompted you, and you require strong password, then you have to create the password as strong as possible!
next thing is to grant all privileges to current user. fyi, arterisk mean all in mysql,
mysql> grant all privileges on *.* to 'username'@'localhost';
final step was flushing and escaping, wkwkwk.
mysql> flush privileges;
mysql> exit;
i dont know that both command above required. Hehehe. It's just a bad practices about how to install mysql-server on your linux.

Komentar (0)
Posting Komentar
Cancel