Cara Install Mysql di Ubuntu 16.04

Cara  Install   Mysql  di Ubuntu  16.04

Tutorial  Linux  Indonesia  -  Mysql  Server  merupakan    databases  server  sangat  popular  dan  banyak  di gunakan  oleh  web  hosting. 

Cara  Install   Mysql  di Ubuntu  16.04
Cara  Install   Mysql  di Ubuntu  16.04


Tentu  mysql  banyak  kelebihan di  bandingakan dengan    databases server  lainya,  seperti  open  source,  mudah  di gunakan  dan   handal  untuk mengatasi   web  server.

Langkah  1  :   Install   Mysql  Server 

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

Langkah 2 :  Anda  berikan  password   untuk  mysql  server

+--------------------+ Configuring mysql-server-5.7 +---------------------+
| While not mandatory, it is highly recommended that you set a password   |
| for the MySQL administrative "root" user.                               |
|                                                                         |
| If this field is left blank, the password will not be changed.          |
|                                                                         |
| New password for the MySQL "root" user:                                 |
|                                                                         |
| ********_________________( Masukan  password  root untuk mysql  server  ) ______________________________________________ |
|                                                                         |
|                                                                     |
|                                                                         |
+-------------------------------------------------------------------------+

Artikel  Terkait 


Cara Menginstall DNS Server di Ubuntu 16.04

Cara Mengistall DHCP SERVER di UBUNTU 16.04


Cara Menginstall SSH di Ubuntu 16.04


Cara Setting IP Address di Ubuntu 16.04



Cara Menambah User Account di Linux Ubuntu 16.04
Langkah 3 : Pengetesan   Mysql Server 

root@client:~# mysql  -u root  -p
Enter password: (  Masukan  password   untuk  Mysql  server  )  
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 5
Server version: 5.7.22-0ubuntu0.16.04.1 (Ubuntu)
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.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> 

Langkah 4 :  Melakukan  Check  akun   Databases  di  Mysql.

mysql> select user,host from mysql.user;
+------------------+-----------+
| user             | host      |
+------------------+-----------+
| debian-sys-maint | localhost |
| mysql.session    | localhost |
| mysql.sys        | localhost |
| root             | localhost |
+------------------+-----------+
4 rows in set (0.05 sec)
mysql> exit
Bye
root@client:~#


 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,