MariaDB インストール2015/05/16 |
MariaDB をインストールし、データベースサーバーを構築します。
|
|
[1] | MariaDB をインストールして起動します。 |
root@www:~#
aptitude -y install mariadb-server-10.0 # インストール中、MariaDB rootパスワードの設定を求められる +-------------------+ Configuring mariadb-server-5.5 +--------------------+ | While not mandatory, it is highly recommended that you set a password | | for the MariaDB administrative "root" user. | | | | If this field is left blank, the password will not be changed. | | | | New password for the MariaDB "root" user: | | | | ********_______________________________________________________________ | | | | <Ok> | | | +-------------------------------------------------------------------------+root@www:~# mysql -u root -p # MariaDBに接続 Enter password: # インストール中に設定したrootパスワード入力 Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 40 Server version: 10.0.16-MariaDB-1 (Debian) Copyright (c) 2000, 2014, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. # ユーザ情報表示 MariaDB [(none)]> select user,host,password from mysql.user; +------------------+-----------+-------------------------------------------+ | user | host | password | +------------------+-----------+-------------------------------------------+ | root | localhost | *247xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx | | root | www | *247xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx | | root | 127.0.0.1 | *247xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx | | root | ::1 | *247xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx | | debian-sys-maint | localhost | *247xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx | +------------------+-----------+-------------------------------------------+ 5 rows in set (0.00 sec)MariaDB [(none)]> exit Bye |
Sponsored Link |
|