mariadb105
をテンプレートにして作成
[
トップ
] [
新規
|
一覧
|
検索
|
最終更新
|
ヘルプ
|
ログイン
]
開始行:
CONTENTS
#contents
----
Lastmodified &lastmod;
----
*mariadb106-server 【Hotshot】【Piano2nd】 [#n659c029]
[[mysql_secure_installation:https://mariadb.com/kb/ja/mys...
https://freebsd.i-mks.site/sql/mariadb_install/
46 16:22 portinstall mariadb106-server
63 9:23 portinstall databases/phpmyadmin5
mariadb106-server phpmyadmin5 の二つをインストール後、M...
81 14:14 /usr/local/etc/rc.d/mysql-server onestart
Installing MariaDB/MySQL system tables in '/var/db/mysql...
OK
To start mariadbd at boot time you have to copy
support-files/mariadb.service to the right place for you...
Two all-privilege accounts were created.
One is root@localhost, it has no password, but you need to
be system 'root' user to connect. Use, for example, sudo...
The second is mysql@localhost, it has no password either...
you need to be the system 'mysql' user to connect.
After connecting you can set the password, if you would ...
able to connect as any of these users with a password an...
See the MariaDB Knowledgebase at https://mariadb.com/kb
You can start the MariaDB daemon with:
cd '/usr/local' ; /usr/local/bin/mariadb-safe --datadir=...
You can test the MariaDB daemon with mysql-test-run.pl
cd '/usr/local/' ; perl mariadb-test-run.pl
Please report any problems at https://mariadb.org/jira
The latest information about MariaDB is available at htt...
Consider joining MariaDB's strong and vibrant community:
https://mariadb.org/get-involved/
Starting mysql.
続いて設定
# mysql_secure_installation
NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FO...
SERVERS IN PRODUCTION USE! PLEASE READ EACH STEP C...
In order to log into MariaDB to secure it, we'll need th...
password for the root user. If you've just installed Mar...
haven't set the root password yet, you should just press...
Enter current password for root (enter for none):
OK, successfully used password, moving on...
と成功したと言っているが、実際には反映されて折らず、相変...
alter user root@localhost identified by 'RootPassword';...
実際には、mysql 上で、コマンドを打つ。
root@localhost [(none)]> alter user root@localhost ident...
を使って後で変更した。
Setting the root password or using the unix_socket ensur...
can log into the MariaDB root user without the proper au...
You already have your root account protected, so you can...
Switch to unix_socket authentication [Y/n]
ここで、Yとすると、phpMyAdmin からの接続で、エラーとなる。
https://webfood.info/phpmyadmin-error-2002/
unix_socket との接続になるので、
# mysql_config --socket
/var/run/mysql/mysql.sock
で、ソケットの所在を確かめた後、/usr/local/www/phpMyAdmin...
//$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['connect_type'] = 'socket';
$cfg['Servers'][$i]['socket'] = '/var/run/mysql/mysql.so...
を追加設定する。と、接続は出来るようになるが、・・・？
&ref(./phpmyadmin_ng.jpeg,,522x214);
という不完全な表示となってしまう。普段見慣れている、
&ref(./phpmyadmin_ok.jpeg,,522x214);
の様な表示にするには、参考サイト https://www.qnap.com/ja...
/usr/local/www/phpMyAdmin/config.inc.php
declare(strict_types=1);
$i = 0;
$cfg['blowfish_secret'] = 'dLJevJqAK3G9HBJKP6R6k10sNKT4s...
$i++;
/* Server parameters */
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['compress'] = false;
$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['socket'] = '/var/run/mysql/mysql.so...
$cfg['Servers'][$i]['AllowNoPassword'] = false;
/* User used to manipulate with storage */
$cfg['Servers'][$i]['controlhost'] = '';
$cfg['Servers'][$i]['controlport'] = '';
$cfg['Servers'][$i]['controluser'] = 'root';
$cfg['Servers'][$i]['controlpass'] = 'RootPassword';
/usr/local/etc/mysql/my.cnf
[client-server]
socket = /var/run/mysql/mysql.sock
[mysqld]
port = 3306
socket = /var/run/mysql/mysql.sock
/usr/local/etc/mysql/conf.d/server.cnf
[mysqld]
#unix_socket=OFF
#disable_unix_socket
で、正常表示と成った様である。(;-･｡･-;)
----
Total access &counter(total);：本日 &counter(today);：昨...
#counter([total|today|yesterday]);
終了行:
CONTENTS
#contents
----
Lastmodified &lastmod;
----
*mariadb106-server 【Hotshot】【Piano2nd】 [#n659c029]
[[mysql_secure_installation:https://mariadb.com/kb/ja/mys...
https://freebsd.i-mks.site/sql/mariadb_install/
46 16:22 portinstall mariadb106-server
63 9:23 portinstall databases/phpmyadmin5
mariadb106-server phpmyadmin5 の二つをインストール後、M...
81 14:14 /usr/local/etc/rc.d/mysql-server onestart
Installing MariaDB/MySQL system tables in '/var/db/mysql...
OK
To start mariadbd at boot time you have to copy
support-files/mariadb.service to the right place for you...
Two all-privilege accounts were created.
One is root@localhost, it has no password, but you need to
be system 'root' user to connect. Use, for example, sudo...
The second is mysql@localhost, it has no password either...
you need to be the system 'mysql' user to connect.
After connecting you can set the password, if you would ...
able to connect as any of these users with a password an...
See the MariaDB Knowledgebase at https://mariadb.com/kb
You can start the MariaDB daemon with:
cd '/usr/local' ; /usr/local/bin/mariadb-safe --datadir=...
You can test the MariaDB daemon with mysql-test-run.pl
cd '/usr/local/' ; perl mariadb-test-run.pl
Please report any problems at https://mariadb.org/jira
The latest information about MariaDB is available at htt...
Consider joining MariaDB's strong and vibrant community:
https://mariadb.org/get-involved/
Starting mysql.
続いて設定
# mysql_secure_installation
NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FO...
SERVERS IN PRODUCTION USE! PLEASE READ EACH STEP C...
In order to log into MariaDB to secure it, we'll need th...
password for the root user. If you've just installed Mar...
haven't set the root password yet, you should just press...
Enter current password for root (enter for none):
OK, successfully used password, moving on...
と成功したと言っているが、実際には反映されて折らず、相変...
alter user root@localhost identified by 'RootPassword';...
実際には、mysql 上で、コマンドを打つ。
root@localhost [(none)]> alter user root@localhost ident...
を使って後で変更した。
Setting the root password or using the unix_socket ensur...
can log into the MariaDB root user without the proper au...
You already have your root account protected, so you can...
Switch to unix_socket authentication [Y/n]
ここで、Yとすると、phpMyAdmin からの接続で、エラーとなる。
https://webfood.info/phpmyadmin-error-2002/
unix_socket との接続になるので、
# mysql_config --socket
/var/run/mysql/mysql.sock
で、ソケットの所在を確かめた後、/usr/local/www/phpMyAdmin...
//$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['connect_type'] = 'socket';
$cfg['Servers'][$i]['socket'] = '/var/run/mysql/mysql.so...
を追加設定する。と、接続は出来るようになるが、・・・？
&ref(./phpmyadmin_ng.jpeg,,522x214);
という不完全な表示となってしまう。普段見慣れている、
&ref(./phpmyadmin_ok.jpeg,,522x214);
の様な表示にするには、参考サイト https://www.qnap.com/ja...
/usr/local/www/phpMyAdmin/config.inc.php
declare(strict_types=1);
$i = 0;
$cfg['blowfish_secret'] = 'dLJevJqAK3G9HBJKP6R6k10sNKT4s...
$i++;
/* Server parameters */
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['compress'] = false;
$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['socket'] = '/var/run/mysql/mysql.so...
$cfg['Servers'][$i]['AllowNoPassword'] = false;
/* User used to manipulate with storage */
$cfg['Servers'][$i]['controlhost'] = '';
$cfg['Servers'][$i]['controlport'] = '';
$cfg['Servers'][$i]['controluser'] = 'root';
$cfg['Servers'][$i]['controlpass'] = 'RootPassword';
/usr/local/etc/mysql/my.cnf
[client-server]
socket = /var/run/mysql/mysql.sock
[mysqld]
port = 3306
socket = /var/run/mysql/mysql.sock
/usr/local/etc/mysql/conf.d/server.cnf
[mysqld]
#unix_socket=OFF
#disable_unix_socket
で、正常表示と成った様である。(;-･｡･-;)
----
Total access &counter(total);：本日 &counter(today);：昨...
#counter([total|today|yesterday]);
ページ名:
![[PukiWiki]](image/pukiwiki.png "[PukiWiki]")
