投稿時間:2023-09-02 13:06:43 RSSフィード2023-09-02 13:00 分まとめ(7件)
カテゴリー等 | サイト名等 | 記事タイトル・トレンドワード等 | リンクURL | 頻出ワード・要約等/検索ボリューム | 登録日 |
---|---|---|---|---|---|
js | JavaScriptタグが付けられた新着投稿 - Qiita | 学習用Webアプリ制作の進め方 | https://qiita.com/smartpoteto/items/7a10a5feeccee2ec0767 | htmlcssjavascriptphp | 2023-09-02 12:28:18 |
技術ブログ | Developers.IO | 【iOSDC Japan 2023 レポート】「TextKit 2 時代の iOS のキーボードとテキスト入力と表示のすべて」を聞いてきた。 | https://dev.classmethod.jp/articles/iosdc-japan-2023-report-06/ | iosdcjapan | 2023-09-02 03:42:29 |
技術ブログ | Developers.IO | EFS のバーストクレジットはどの様に蓄積されるのか教えてください | https://dev.classmethod.jp/articles/tsnote-efs-bursting-throughput-mode-accumulation-performance/ | cloudwatch | 2023-09-02 03:30:43 |
技術ブログ | Developers.IO | 【レポート】レイトレ時代のゲームグラフィックス Vol.2 – ハイエンドタイトル制作向けゲーム実行環境とつながる制作環境の取り組み紹介 #CEDEC2023 #classmethod_game | https://dev.classmethod.jp/articles/cedec2023_raytrace/ | cedec | 2023-09-02 03:08:27 |
海外TECH | DEV Community | MariaDB 10.9 on OpenBSD 7.3: Install | https://dev.to/nabbisen/mariadb-109-on-openbsd-73-install-4e73 | MariaDB on OpenBSD Install SummaryMariaDB is one of the popular relational database management systems RDBMS forked from MySQL by some of the original developers It is open source licensed under GNU GPL and ready for both community and enterprise use with long history and large knowledge to manage and maintain To Install it on OpenBSD the solid and clean operating system is easy thanks to the Package Management system ports maintained by the great project and the community This post shows how to do it EnvironmentOS OpenBSD Database MariaDB Basic stepsJust a few pkg add mariadb server rcctl enable mysqld mysql install db rcctl start mysqld mysql secure installation several questions will be givenAll of the description is below Tutorial Install the package doas pkg add mariadb serverThe result was quirks signed on T Zmariadb server v okmariadb server v okThe following new rcscripts were installed etc rc d mysqldSee rcctl for details New and changed readme s usr local share doc pkg readmes mariadb serverAs above the pkg readme is brought as usr local share doc pkg readmes mariadb server Activate daemon doas rcctl enable mysqld Run mysql install dbCreate the default database doas mysql install dbThe result was WARNING The host could not be looked up with usr local bin resolveip This probably means that your libc libraries are not compatiblewith this binary MariaDB version The MariaDB daemon mysqld should worknormally with the exception that host name resolving will not work This means that you should use IP addresses instead of hostnameswhen specifying MariaDB privileges Installing MariaDB MySQL system tables in var mysql OKTwo all privilege accounts were created One is root localhost it has no password but you need tobe system root user to connect Use for example sudo mysqlThe second is mysql localhost it has no password either butyou need to be the system mysql user to connect After connecting you can set the password if you would need to beable to connect as any of these users with a password and without sudoSee the MariaDB Knowledgebase at You can start the MariaDB daemon with etc rc d mysqld startPlease report any problems at The latest information about MariaDB is available at Consider joining MariaDB s strong and vibrant community Start daemon doas rcctl start mysqldmysqld ok Run mysql secure installation doas mysql secure installation Start Before the questions NOTE RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MariaDB SERVERS IN PRODUCTION USE PLEASE READ EACH STEP CAREFULLY Several questions givenActually they are up to your environment Q Current root passwordIt must be none for the first time In order to log into MariaDB to secure it we ll need the currentpassword for the root user If you ve just installed MariaDB andhaven 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 Q Use unix socket authentication instead of root passwordSetting the root password or using the unix socket ensures that nobodycan 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 n skipping Q Set root passwordYou already have your root account protected so you can safely answer n Change the root password Y n yNew password Re enter new password Password updated successfully Q Remove anonymous usersBy default a MariaDB installation has an anonymous user allowing anyoneto log into MariaDB without having to have a user account created forthem This is intended only for testing and to make the installationgo a bit smoother You should remove them before moving into aproduction environment Remove anonymous users Y n y Success Q Disallow root login remotelyNormally root should only be allowed to connect from localhost Thisensures that someone cannot guess at the root password from the network Disallow root login remotely Y n y Success Q Remove test databaseBy default MariaDB comes with a database named test that anyone canaccess This is also intended only for testing and should be removedbefore 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 Q Reload privilege tablesReloading the privilege tables will ensure that all changes made so farwill take effect immediately Reload privilege tables now Y n y Success End The rest Cleaning up All done If you ve completed all of the above steps your MariaDBinstallation should now be secure Thanks for using MariaDB ConclusionYou may confirm your daemon is fine with doas rcctl check mysqldmysqld ok Well let s login to the server as client with root the superuser mysql u root pAfter entering the password you must be welcomed Welcome to the MariaDB monitor Commands end with or g Your MariaDB connection id is Server version MariaDB OpenBSD port mariadb server vCopyright c Oracle MariaDB Corporation Ab and others Type help or h for help Type c to clear the current input statement MariaDB none gt The command line examples create databaseCREATE DATABASE lt database gt CHARACTER SET utfmb COLLATE utfmb unicode ci create user for itGRANT ALL PRIVILEGES ON lt database gt TO lt dbuser gt localhost IDENTIFIED BY lt dbpass gt reload privilegesFLUSH PRIVILEGES Happy storing digitally | 2023-09-02 03:12:00 |
ニュース | BBC News - Home | Inmates free 57 Ecuador prison guards after stand-off | https://www.bbc.co.uk/news/world-latin-america-66691767?at_medium=RSS&at_campaign=KARANGA | criminal | 2023-09-02 03:09:08 |
ニュース | BBC News - Home | The Papers: Al-Fayed dies and 'concrete chaos' at schools | https://www.bbc.co.uk/news/blogs-the-papers-66691238?at_medium=RSS&at_campaign=KARANGA | mohamed | 2023-09-02 03:23:07 |
コメント
コメントを投稿