Showing posts with label MariaDB. Show all posts
Showing posts with label MariaDB. Show all posts

Cara Install MariaDB di Ubuntu 16.04

Cara  Install  MariaDB di  Ubuntu 16.04

Tutorial  Linux  Indonesia --  Mysql  sampe  saat  ini    menjadi  databases  server   terpopuler  di   web  hosting, selain   gratis  dan handal.

Cara  Install  MariaDB di  Ubuntu 16.04
Cara  Install  MariaDB di  Ubuntu 16.04

Tapi  sekarang  sudah  muncul   yang  baru  yaitu   MariaDB.  MariaDB  merupakan  pecahan  dari  Mysql.   Perkembangan  sangat  cepat. 

Pada  artikel  ini  bagol69  akan  membahas  cara  install MariaDB  di  Ubuntu  16.04.

Langkah  1 :  Install  MariaDB 

root@bagol69:~# apt-get install mariadb-server -y
Reading package lists... Done
Building dependency tree
Reading state information... Done
mariadb-server is already the newest version (10.0.34-0ubuntu0.16.04.1).
0 upgraded, 0 newly installed, 0 to remove and 4 not upgraded.
root@bagol69:~#

Langkah 2 : Konfigurasi   MariaDB 

root@bagol69:~# nano  /etc/mysql/mariadb.conf.d/50-server.cnf
character-set-server  = utf8
#collation-server      = utf8mb4_general_ci


Langkah 3 :  Anda Berikan  Password  untuk  MariaDB.


root@bagol69:~# mysql_secure_installation
 
NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MariaDB
      SERVERS IN PRODUCTION USE!  PLEASE READ EACH STEP CAREFULLY!
 
In order to log into MariaDB to secure it, we'll need the current
password for the root user.  If you've just installed MariaDB, and
you haven't set the root password yet, the password will be blank,
so you should just press enter here.
 
Enter current password for root (enter for none):
OK, successfully used password, moving on...
 
Setting the root password ensures that nobody can log into the MariaDB
root user without the proper authorisation.
 
Set root password? [Y/n] Y
New password: (    Berikan  password  untuk  mariadb )
Re-enter new password: ( berikan  password  untuk  mariadb ) 
Password updated successfully!
Reloading privilege tables..
 ... Success!
 
 
By default, a MariaDB installation has an anonymous user, allowing anyone
to log into MariaDB 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? [Y/n] 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? [Y/n] y
 ... Success!
 
By default, MariaDB 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? [Y/n] 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? [Y/n] y
 ... Success!
Cleaning up...
All done!  If you've completed all of the above steps, your MariaDB
installation should now be secure.
 
Thanks for using MariaDB!
root@bagol69:~#


Artikel  Terkait 

Cara Install Mysql di Ubuntu 16.04


Cara Menginstall SSH di Ubuntu 16.04



Langkah 4:  Melakukan  Pengetesan   Databases  Server MariaDB.


root@bagol69:~# mysql -u root -p
Enter password: (  Masukan  Password  MariaDB ) 
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 40
Server version: 10.0.34-MariaDB-0ubuntu0.16.04.1 Ubuntu 16.04
 
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
 
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
 
MariaDB [(none)]>
#  melihat    user    yang  ada  di  mariadb
MariaDB [(none)]> select user,host,password from mysql.user;
+------+-----------+-------------------------------------------+
| user | host      | password                                  |
+------+-----------+-------------------------------------------+
| root | localhost | *297CF42143AE0E3683F61D262A9270D4EE4BECFC |
+------+-----------+-------------------------------------------+
1 row in set (0.04 sec)
 
MariaDB [(none)]>
# Untuk  melihat    databases  yang ada  di  Mariadb
MariaDB [(none)]> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
+--------------------+
3 rows in set (0.08 sec)
 
MariaDB [(none)]>

 Anda  merasa  tutorial  ini bermanfaat ?  
BBagikan  dengan teman-teman  anda, untuk membuat tetap  hidup.
Untuk  topic bantuan  lebih lanjut, Jelajahi  situs web  kami,
http://www.bagol69.com
jjadilah  yang pertama  berkomentar,


Kategori

Kategori