mariadb105 の履歴差分(No.5)

• 履歴一覧
• 現在との差分 を表示
• ソース を表示
• 履歴 を表示
• mariadb105 へ行く。
  • 1 (2022-09-20 (火) 16:22:17)
  • 2 (2022-09-20 (火) 16:22:43)
  • 3 (2022-09-22 (木) 14:49:53)
  • 4 (2023-05-23 (火) 13:13:15)
  • 5 (2023-07-06 (木) 12:41:43)
  • 6 (2023-07-06 (木) 13:42:59)
  • 7 (2023-09-11 (月) 10:55:44)
  • 8 (2023-10-13 (金) 13:31:19)
  • 9 (2023-10-13 (金) 13:33:29)

• 追加された行はこの色です。
• 削除された行はこの色です。

#author("2023-05-23T13:13:15+09:00","default:kuji","kuji")
#author("2023-07-05T10:34:29+09:00","default:kuji","kuji")
CONTENTS
#contents
----
Lastmodified　&lastmod;
----
*mariadb105-server [#m9fdabab]
https://freebsd.i-mks.site/sql/mariadb_install/

    46  16:22   portinstall mariadb105-server
    63  9:23    portinstall databases/phpmyadmin
    81  14:14   /usr/local/etc/rc.d/mysql-server onestart
    83  14:16   mysql_secure_installation

 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 your system
 
 
 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 mysql
 The second is mysql@localhost, it has no password either, but
 you need to be the system 'mysql' user to connect.
 After connecting you can set the password, if you would need to be
 able to connect as any of these users with a password and without sudo
 
 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='/var/db/mysql'
 
 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 https://mariadb.org/.
 
 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 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
 haven't set the root password yet, you should just press enter here.
 
 Enter current password for root (enter for none):

 OK, successfully used password, moving on...
 
 Setting the root password or using the unix_socket ensures that nobody
 can log into the MariaDB root user without the proper authorisation.
 
 You already have your root account protected, so you can safely answer 'n'.
 
 Switch to unix_socket authentication [Y/n]

ここで、Yとすると、phpMyAdmin からの接続で、エラーとなる。

unix_socket との接続になるので、

 # mysql_config --socket
 /var/run/mysql/mysql.sock

で、ソケットの所在を確かめた後、/usr/local/www/phpMyAdmin/config.inc.php に

 //$cfg['Servers'][$i]['connect_type'] = 'tcp';
 $cfg['Servers'][$i]['connect_type'] = 'socket';
 $cfg['Servers'][$i]['socket'] = '/var/run/mysql/mysql.sock';
を追加設定する。と、接続は出来るようになるが、・・・？






[[.php にアクセスするとダウンロードになる！]]
----
Total access &counter(total);：本日 &counter(today);：昨日 &counter(yesterday);
#counter([total|today|yesterday]);