Artikel ini akan membahas bagaimana cara melakukan installasi mysql pada ubuntu server 18.04 LTS. Langsung saja simak langkah-langkah dibawah ini. Langkah pertama lakukan update dan upgrade pada os yang digunakan menggunakan perintah dibawah ini
sudo apt-get updata sudo apt-get upgrade
Jika update dan upgrade sudah selesai maka lakukan reboot server, jalankan perintah berikut
reboot
Setelah reboot langkah selanjutnya melakukan installasi mysqlnya, jalankan perintah berikut
sudo apt-get install mysql-server
Kemudian cek status mysql apakah sudah berjalan atau belum
# service mysql status ● mysql.service - MySQL Community Server Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled) Active: active (running) since Tue 2018-08-07 09:00:18 UTC; 17h ago Main PID: 3431 (mysqld) Tasks: 29 (limit: 1110) CGroup: /system.slice/mysql.service └─3431 /usr/sbin/mysqld --daemonize --pid-file=/run/mysqld/mysqld.pid Aug 07 09:00:17 rahmat systemd[1]: Starting MySQL Community Server... Aug 07 09:00:18 rahmat systemd[1]: Started MySQL Community Server.
Agar lebih aman kita perlu melakukan setingan tambahan, jalankan perintah berikut
mysql_secure_installation
Kurang lebih outputnya seperti berikut ini
# mysql_secure_installation Securing the MySQL server deployment. Connecting to MySQL using a blank password. VALIDATE PASSWORD PLUGIN can be used to test passwords and improve security. It checks the strength of password and allows the users to set only those passwords which are secure enough. Would you like to setup VALIDATE PASSWORD plugin? Press y|Y for Yes, any other key for No: Please set the password for root here. New password: Re-enter new password: By default, a MySQL installation has an anonymous user, allowing anyone to log into MySQL without having to have a user account created for them. This is intended only for testing, and to make the installation go a bit smoother. You should remove them before moving into a production environment. Remove anonymous users? (Press y|Y for Yes, any other key for No) : y Success. Normally, root should only be allowed to connect from 'localhost'. This ensures that someone cannot guess at the root password from the network. Disallow root login remotely? (Press y|Y for Yes, any other key for No) : ... skipping. By default, MySQL comes with a database named 'test' that anyone can access. This is also intended only for testing, and should be removed before moving into a production environment. Remove test database and access to it? (Press y|Y for Yes, any other key for No) : y - Dropping test database... Success. - Removing privileges on test database... Success. Reloading the privilege tables will ensure that all changes made so far will take effect immediately. Reload privilege tables now? (Press y|Y for Yes, any other key for No) : y Success. All done!
Jika sudah selesai bisa login ke mysql menggunakan perintah berikut ini
mysql -u root -p
Untuk melihat versi mysql yang digunakan bisa jalankan perintah berikut
mysqladmin -u root -p version
Outputnya seperti berikut
mysqladmin Ver 8.42 Distrib 5.7.23, for Linux on x86_64 Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Server version 5.7.23-0ubuntu0.18.04.1 Protocol version 10 Connection Localhost via UNIX socket UNIX socket /var/run/mysqld/mysqld.sock Uptime: 16 hours 58 min 23 sec
Selanjutnya untuk membuat database dan username database, menggunakan perintah berikut,
CREATE DATABASE dbname; USE dbname; CREATE USER 'dbuser'@'localhost' IDENTIFIED BY 'password-dbuser'; GRANT ALL PRIVILEGES ON *.* TO 'dbuser'@'localhost'; FLUSH PRIVILEGES;
Nah mudah bukan, selamat mencoba ya semoga berhasil 😛
E: Could not get lock /var/lib/dpkg/lock-frontend – open (11: Resource temporarily unavailable)
E: Unable to acquire the dpkg frontend lock (/var/lib/dpkg/lock-frontend), is another process using it?
itu gmn min??
berarti masih ada proses yang berjalan pak, coba di cek
# lsof /var/lib/dpkg/lock-frontend
Lalu jika sudah ketemu, matikan prosesnya
# sudo kill -9 PID
Setelah itu remove filenya dan configuraskan kembali
# sudo rm /var/lib/dpkg/lock-frontend
# sudo dpkg –configure -a
Semoga membantu 🙂