10:MySQL-server ########################################### [ 70%]
\nPLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
\nTo do so, start the server, then issue the following commands:
\n\/usr\/bin\/mysqladmin -u root password ‘new-password’
\n\/usr\/bin\/mysqladmin -u root -h genu password ‘new-password’
\nSee the manual for more instructions.
\nNOTE: If you are upgrading from a MySQL <= 3.22.10 you should run\nthe \/usr\/bin\/mysql_fix_privilege_tables. Otherwise you will not be\nable to use the new GRANT command!\nPlease report any problems with the \/usr\/bin\/mysqlbug script!\nThe latest information about MySQL is available on the web at\nhttp:\/\/www.mysql.com\nSupport MySQL by buying support\/licenses at http:\/\/shop.mysql.com\nStarting MySQL...................................[FAILED]\n# rpm -qa | grep MySQL\nMySQL-devel-5.0.27-0vl6\nMySQL-embedded-5.0.27-0vl6\nMySQL-Max-5.0.27-0vl6\nperl-DBD-MySQL-4.001-0vl1\nMySQL-shared-5.0.27-0vl6\nMySQL-server-5.0.27-0vl6\nMySQL-client-5.0.27-0vl6\n\u691c\u7d22\u3057\u305f\u3089\u30ea\u30d3\u30eb\u30c8\u3057\u3066\u5165\u308c\u306a\u304a\u3057\u305f\u3089\u3001\u305f\u3061\u3042\u304c\u3063\u305f\u3068\u3044\u3046\u304b\u305f\u304c\n\u3061\u3089\u307b\u3089\u3044\u305f\u306e\u3067\u3001\u3084\u3063\u3066\u307f\u308b\u3002\n#cd \/usr\/local\/src\n#wget http:\/\/updates.vinelinux.org\/VinePlus\/4.2\/SRPMS.extras\/MySQL-5.0.27-0vl6.src.rpm\nrpm -ivh MySQL-5.0.27-0vl6.src.rpm\n# cd \/usr\/src\/vine\/SPECS\/\n# ls -l\n\u5408\u8a08 36\n-rw-r--r-- 1 root root 34814 12\u670813\u65e5 2007 mysql50-vl.spec\n#rpm -bb mysql50-vl.spec\n\u304b\u306a\u30fc\u308a\u3000\u6642\u9593\u304b\u304b\u308a\u307e\u3059\n\/usr\/src\/vine\/RPMS\/i386\u306e\u4e2d\u306brpm\u304c\u3067\u304d\u307e\u3059\u3002\n\u4eca\u56de server\u3068max\u3092\u3000\u5165\u308c\u306a\u304a\u3057\u3066\u3000\u3000initt\u30006\u3000\u3067\u7acb\u3061\u4e0a\u3052\u306a\u304a\u3057\u305f\u3089\n\u7acb\u3061\u4e0a\u304c\u308b\u3088\u3046\u306b\u306a\u308a\u307e\u3057\u305f\u3002\n# cd \/usr\/src\/vine\/RPMS\/\n[root@localhost RPMS]# ls -l\n\u5408\u8a08 24\ndrwxr-xr-x 2 root root 4096 12\u670814\u65e5 2007 athlon\/\ndrwxr-xr-x 2 root root 4096 1\u670829\u65e5 20:07 i386\/\ndrwxr-xr-x 2 root root 4096 12\u670814\u65e5 2007 i486\/\ndrwxr-xr-x 2 root root 4096 12\u670814\u65e5 2007 i586\/\ndrwxr-xr-x 2 root root 4096 12\u670814\u65e5 2007 i686\/\ndrwxr-xr-x 2 root root 4096 12\u670814\u65e5 2007 noarch\/\ncd i386\/\n# ls -l\n\u5408\u8a08 50928\n-rw-r--r-- 1 root root 3354230 1\u670829\u65e5 20:07 MySQL-Max-5.0.27-0vl6.i386.rpm\n-rw-r--r-- 1 root root 6097674 1\u670829\u65e5 20:07 MySQL-bench-5.0.27-0vl6.i386.rpm\n-rw-r--r-- 1 root root 6489432 1\u670829\u65e5 20:07 MySQL-client-5.0.27-0vl6.i386.rpm\n-rw-r--r-- 1 root root 3667208 1\u670829\u65e5 20:07 MySQL-devel-5.0.27-0vl6.i386.rpm\n-rw-r--r-- 1 root root 3574227 1\u670829\u65e5 20:07 MySQL-embedded-5.0.27-0vl6.i386.rpm\n-rw-r--r-- 1 root root 2730575 1\u670829\u65e5 20:07 MySQL-ndb-extra-5.0.27-0vl6.i386.rpm\n-rw-r--r-- 1 root root 1851642 1\u670829\u65e5 20:07 MySQL-ndb-management-5.0.27-0vl6.i386.rpm\n-rw-r--r-- 1 root root 1622499 1\u670829\u65e5 20:07 MySQL-ndb-storage-5.0.27-0vl6.i386.rpm\n-rw-r--r-- 1 root root 6238196 1\u670829\u65e5 20:07 MySQL-ndb-tools-5.0.27-0vl6.i386.rpm\n-rw-r--r-- 1 root root 14841698 1\u670829\u65e5 20:06 MySQL-server-5.0.27-0vl6.i386.rpm\n-rw-r--r-- 1 root root 1573119 1\u670829\u65e5 20:07 MySQL-shared-5.0.27-0vl6.i386.rpm\n# mysql -u root -p\nEnter password:\nWelcome to the MySQL monitor. Commands end with ; or \\g.\nYour MySQL connection id is 220 to server version: 5.0.27-Max\nType 'help;' or '\\h' for help. Type '\\c' to clear the buffer.\nmysql>
\nmysql>
\nmysql> SHOW VARIABLES LIKE ‘character\\_set\\_%’;
\n+————————–+——–+
\n| Variable_name | Value |
\n+————————–+——–+
\n| character_set_client | utf8 |
\n| character_set_connection | utf8 |
\n| character_set_database | utf8 |
\n| character_set_filesystem | binary |
\n| character_set_results | utf8 |
\n| character_set_server | utf8 |
\n| character_set_system | utf8 |
\n+————————–+——–+
\n7 rows in set (0.01 sec)
\nmysql><\/p>\n","protected":false},"excerpt":{"rendered":"
10:MySQL-server ########################################### [ 70%] PLEASE REMEMBER TO SET A PASSWORD FOR THE M […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[3,4],"tags":[21],"class_list":["post-46","post","type-post","status-publish","format-standard","hentry","category-linux","category-4","tag-mysql-5-0-27"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/tsk-server.com\/index.php?rest_route=\/wp\/v2\/posts\/46","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tsk-server.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tsk-server.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tsk-server.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/tsk-server.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=46"}],"version-history":[{"count":1,"href":"https:\/\/tsk-server.com\/index.php?rest_route=\/wp\/v2\/posts\/46\/revisions"}],"predecessor-version":[{"id":1467,"href":"https:\/\/tsk-server.com\/index.php?rest_route=\/wp\/v2\/posts\/46\/revisions\/1467"}],"wp:attachment":[{"href":"https:\/\/tsk-server.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=46"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tsk-server.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=46"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tsk-server.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=46"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}