{"id":116,"date":"2015-04-30T08:04:14","date_gmt":"2015-04-30T08:04:14","guid":{"rendered":"http:\/\/localhost\/blog\/?p=116"},"modified":"2015-04-30T08:05:43","modified_gmt":"2015-04-30T08:05:43","slug":"mysql-server","status":"publish","type":"post","link":"http:\/\/www.mandcgroup.in\/blog\/mysql-server\/","title":{"rendered":"MySQL Server"},"content":{"rendered":"<p><strong>[root@www ~]#<\/strong> yum install mysql*<br \/>\nLoaded plugins: refresh-packagekit, rhnplugin<br \/>\nThis system is not registered with RHN.<br \/>\nRHN support will be disabled.<br \/>\nSetting up Install Process<br \/>\n<!--more--><\/p>\n<div class=\"entry-content\">\n<p style=\"text-align: justify;\">Package mysql-server-5.1.47-4.el6.x86_64 already installed and latest version<br \/>\nPackage mysql-libs-5.1.47-4.el6.x86_64 already installed and latest version<\/p>\n<p style=\"text-align: justify;\">Package mysql-5.1.47-4.el6.x86_64 already installed and latest version<br \/>\nResolving Dependencies<br \/>\n\u2013&gt; Running transaction check<br \/>\n\u2014&gt; Package mysql-bench.x86_64 0:5.1.47-4.el6 set to be updated<br \/>\n\u2014&gt; Package mysql-connector-java.x86_64 1:5.1.12-2.el6 set to be updated<br \/>\n\u2013&gt; Processing Dependency: java-gcj-compat &gt;= 1.0.31 for package: 1:mysql-connector-java-5.1.12-2.el6.x86_64<br \/>\n\u2013&gt; Processing Dependency: java-gcj-compat &gt;= 1.0.31 for package: 1:mysql-connector-java-5.1.12-2.el6.x86_64<br \/>\n\u2013&gt; Processing Dependency: jta &gt;= 1.0 for package: 1:mysql-connector-java-5.1.12-2.el6.x86_64<br \/>\n\u2013&gt; Processing Dependency: log4j for package: 1:mysql-connector-java-5.1.12-2.el6.x86_64<br \/>\n\u2013&gt; Processing Dependency: libgcj_bc.so.1()(64bit) for package: 1:mysql-connector-java-5.1.12-2.el6.x86_64<br \/>\n\u2014&gt; Package mysql-connector-odbc.x86_64 0:5.1.5r1144-7.el6 set to be updated<br \/>\n\u2014&gt; Package mysql-devel.x86_64 0:5.1.47-4.el6 set to be updated<br \/>\n\u2013&gt; Processing Dependency: openssl-devel for package: mysql-devel-5.1.47-4.el6.x86_64<br \/>\n\u2014&gt; Package mysql-test.x86_64 0:5.1.47-4.el6 set to be updated<br \/>\n\u2013&gt; Running transaction check<br \/>\n\u2014&gt; Package geronimo-specs-compat.noarch 0:1.0-3.4.M2.el6 set to be updated<br \/>\n\u2013&gt; Processing Dependency: geronimo-specs = 1.0-3.4.M2.el6 for package: geronimo-specs-compat-1.0-3.4.M2.el6.noarch<br \/>\n\u2014&gt; Package java-1.5.0-gcj.x86_64 0:1.5.0.0-29.1.el6 set to be updated<br \/>\nserver\/filelists                                                             | 3.3 MB     00:00<br \/>\n\u2013&gt; Processing Dependency: sinjdoc for package: java-1.5.0-gcj-1.5.0.0-29.1.el6.x86_64<br \/>\n\u2014&gt; Package libgcj.x86_64 0:4.4.4-13.el6 set to be updated<br \/>\n\u2014&gt; Package log4j.x86_64 0:1.2.14-6.4.el6 set to be updated<br \/>\n\u2013&gt; Processing Dependency: xml-commons-apis for package: log4j-1.2.14-6.4.el6.x86_64<br \/>\n\u2014&gt; Package openssl-devel.x86_64 0:1.0.0-4.el6 set to be updated<br \/>\n\u2013&gt; Processing Dependency: zlib-devel for package: openssl-devel-1.0.0-4.el6.x86_64<br \/>\n\u2013&gt; Processing Dependency: krb5-devel for package: openssl-devel-1.0.0-4.el6.x86_64<br \/>\n\u2013&gt; Running transaction check<br \/>\n\u2014&gt; Package geronimo-specs.noarch 0:1.0-3.4.M2.el6 set to be updated<br \/>\n\u2013&gt; Processing Dependency: mx4j &gt;= 2.0.1 for package: geronimo-specs-1.0-3.4.M2.el6.noarch<br \/>\n\u2013&gt; Processing Dependency: apache-tomcat-apis for package: geronimo-specs-1.0-3.4.M2.el6.noarch<br \/>\n\u2014&gt; Package krb5-devel.x86_64 0:1.8.2-3.el6 set to be updated<br \/>\n\u2013&gt; Processing Dependency: libcom_err-devel for package: krb5-devel-1.8.2-3.el6.x86_64<br \/>\n\u2013&gt; Processing Dependency: keyutils-libs-devel for package: krb5-devel-1.8.2-3.el6.x86_64<br \/>\n\u2013&gt; Processing Dependency: libselinux-devel for package: krb5-devel-1.8.2-3.el6.x86_64<br \/>\n\u2014&gt; Package sinjdoc.x86_64 0:0.5-9.1.el6 set to be updated<br \/>\n\u2013&gt; Processing Dependency: java_cup &gt;= 0.10 for package: sinjdoc-0.5-9.1.el6.x86_64<br \/>\n\u2014&gt; Package xml-commons-apis.x86_64 0:1.3.04-3.6.el6 set to be updated<br \/>\n\u2014&gt; Package zlib-devel.x86_64 0:1.2.3-25.el6 set to be updated<br \/>\n\u2013&gt; Running transaction check<br \/>\n\u2014&gt; Package apache-tomcat-apis.noarch 0:0.1-1.el6 set to be updated<br \/>\n\u2014&gt; Package java_cup.x86_64 1:0.10k-5.el6 set to be updated<br \/>\n\u2014&gt; Package keyutils-libs-devel.x86_64 0:1.4-1.el6 set to be updated<br \/>\n\u2014&gt; Package libcom_err-devel.x86_64 0:1.41.12-3.el6 set to be updated<br \/>\n\u2014&gt; Package libselinux-devel.x86_64 0:2.0.94-2.el6 set to be updated<br \/>\n\u2013&gt; Processing Dependency: libsepol-devel &gt;= 2.0.32-1 for package: libselinux-devel-2.0.94-2.el6.x86_64<br \/>\n\u2013&gt; Processing Dependency: pkgconfig(libsepol) for package: libselinux-devel-2.0.94-2.el6.x86_64<br \/>\n\u2014&gt; Package mx4j.noarch 1:3.0.1-9.13.el6 set to be updated<br \/>\n\u2013&gt; Processing Dependency: axis &gt;= 1.1 for package: 1:mx4j-3.0.1-9.13.el6.noarch<br \/>\n\u2013&gt; Processing Dependency: bcel &gt;= 5.0 for package: 1:mx4j-3.0.1-9.13.el6.noarch<br \/>\n\u2013&gt; Processing Dependency: jakarta-commons-logging &gt;= 1.0.1 for package: 1:mx4j-3.0.1-9.13.el6.noarch<br \/>\n\u2013&gt; Processing Dependency: javamail &gt;= 1.2-5jpp for package: 1:mx4j-3.0.1-9.13.el6.noarch<br \/>\n\u2013&gt; Processing Dependency: jaf for package: 1:mx4j-3.0.1-9.13.el6.noarch<br \/>\n\u2013&gt; Processing Dependency: xml-commons-resolver for package: 1:mx4j-3.0.1-9.13.el6.noarch<br \/>\n\u2013&gt; Running transaction check<br \/>\n\u2014&gt; Package axis.noarch 0:1.2.1-7.2.el6 set to be updated<br \/>\n\u2013&gt; Processing Dependency: jakarta-commons-httpclient for package: axis-1.2.1-7.2.el6.noarch<br \/>\n\u2013&gt; Processing Dependency: jakarta-commons-discovery for package: axis-1.2.1-7.2.el6.noarch<br \/>\n\u2013&gt; Processing Dependency: wsdl4j for package: axis-1.2.1-7.2.el6.noarch<br \/>\n\u2014&gt; Package bcel.x86_64 0:5.2-7.2.el6 set to be updated<br \/>\n\u2013&gt; Processing Dependency: regexp for package: bcel-5.2-7.2.el6.x86_64<br \/>\n\u2014&gt; Package classpathx-jaf.x86_64 0:1.0-15.4.el6 set to be updated<br \/>\n\u2014&gt; Package classpathx-mail.noarch 0:1.1.1-9.4.el6 set to be updated<br \/>\n\u2014&gt; Package jakarta-commons-logging.noarch 0:1.0.4-10.el6 set to be updated<br \/>\n\u2014&gt; Package libsepol-devel.x86_64 0:2.0.41-3.el6 set to be updated<br \/>\n\u2014&gt; Package xml-commons-resolver.x86_64 0:1.1-4.18.el6 set to be updated<br \/>\n\u2013&gt; Running transaction check<br \/>\n\u2014&gt; Package jakarta-commons-discovery.noarch 1:0.4-5.4.el6 set to be updated<br \/>\n\u2014&gt; Package jakarta-commons-httpclient.x86_64 1:3.1-0.6.el6 set to be updated<br \/>\n\u2014&gt; Package regexp.x86_64 0:1.5-4.4.el6 set to be updated<br \/>\n\u2014&gt; Package wsdl4j.noarch 0:1.5.2-7.8.el6 set to be updated<br \/>\n\u2013&gt; Finished Dependency Resolution<\/p>\n<p style=\"text-align: justify;\">Dependencies Resolved<\/p>\n<p style=\"text-align: justify;\">====================================================================================================<br \/>\nPackage                            Arch           Version                     Repository      Size<br \/>\n====================================================================================================<br \/>\nInstalling:<br \/>\nmysql-bench                        x86_64         5.1.47-4.el6                server         426 k<br \/>\nmysql-connector-java               x86_64         1:5.1.12-2.el6              server         2.1 M<br \/>\nmysql-connector-odbc               x86_64         5.1.5r1144-7.el6            server         114 k<br \/>\nmysql-devel                        x86_64         5.1.47-4.el6                server         124 k<br \/>\nmysql-test                         x86_64         5.1.47-4.el6                server         4.9 M<br \/>\nInstalling for dependencies:<br \/>\napache-tomcat-apis                 noarch         0.1-1.el6                   server         163 k<br \/>\naxis                               noarch         1.2.1-7.2.el6               server         1.5 M<br \/>\nbcel                               x86_64         5.2-7.2.el6                 server         1.4 M<br \/>\nclasspathx-jaf                     x86_64         1.0-15.4.el6                server         100 k<br \/>\nclasspathx-mail                    noarch         1.1.1-9.4.el6               server         479 k<br \/>\ngeronimo-specs                     noarch         1.0-3.4.M2.el6              server         110 k<br \/>\ngeronimo-specs-compat              noarch         1.0-3.4.M2.el6              server         6.9 k<br \/>\njakarta-commons-discovery          noarch         1:0.4-5.4.el6               server          73 k<br \/>\njakarta-commons-httpclient         x86_64         1:3.1-0.6.el6               server         580 k<br \/>\njakarta-commons-logging            noarch         1.0.4-10.el6                server          52 k<br \/>\njava-1.5.0-gcj                     x86_64         1.5.0.0-29.1.el6            server         146 k<br \/>\njava_cup                           x86_64         1:0.10k-5.el6               server         197 k<br \/>\nkeyutils-libs-devel                x86_64         1.4-1.el6                   server          28 k<br \/>\nkrb5-devel                         x86_64         1.8.2-3.el6                 server         1.2 M<br \/>\nlibcom_err-devel                   x86_64         1.41.12-3.el6               server          30 k<br \/>\nlibgcj                             x86_64         4.4.4-13.el6                server          19 M<br \/>\nlibselinux-devel                   x86_64         2.0.94-2.el6                server         135 k<br \/>\nlibsepol-devel                     x86_64         2.0.41-3.el6                server          64 k<br \/>\nlog4j                              x86_64         1.2.14-6.4.el6              server         679 k<br \/>\nmx4j                               noarch         1:3.0.1-9.13.el6            server         1.1 M<br \/>\nopenssl-devel                      x86_64         1.0.0-4.el6                 server         1.1 M<br \/>\nregexp                             x86_64         1.5-4.4.el6                 server         105 k<br \/>\nsinjdoc                            x86_64         0.5-9.1.el6                 server         705 k<br \/>\nwsdl4j                             noarch         1.5.2-7.8.el6               server         157 k<br \/>\nxml-commons-apis                   x86_64         1.3.04-3.6.el6              server         439 k<br \/>\nxml-commons-resolver               x86_64         1.1-4.18.el6                server         145 k<br \/>\nzlib-devel                         x86_64         1.2.3-25.el6                server          43 k<\/p>\n<p style=\"text-align: justify;\">Transaction Summary<br \/>\n====================================================================================================<br \/>\nInstall      32 Package(s)<br \/>\nUpgrade       0 Package(s)<\/p>\n<p style=\"text-align: justify;\">Total download size: 37 M<br \/>\nInstalled size: 204 M<br \/>\n<strong>Is this ok [y\/N]: y<\/strong><br \/>\nDownloading Packages:<br \/>\n(1\/32): apache-tomcat-apis-0.1-1.el6.noarch.rpm                              | 163 kB     00:00<br \/>\n(2\/32): axis-1.2.1-7.2.el6.noarch.rpm                                        | 1.5 MB     00:00<br \/>\n(3\/32): bcel-5.2-7.2.el6.x86_64.rpm                                          | 1.4 MB     00:00<br \/>\n(4\/32): classpathx-jaf-1.0-15.4.el6.x86_64.rpm                               | 100 kB     00:00<br \/>\n(5\/32): classpathx-mail-1.1.1-9.4.el6.noarch.rpm                             | 479 kB     00:00<br \/>\n(6\/32): geronimo-specs-1.0-3.4.M2.el6.noarch.rpm                             | 110 kB     00:00<br \/>\n(7\/32): geronimo-specs-compat-1.0-3.4.M2.el6.noarch.rpm                      | 6.9 kB     00:00<br \/>\n(8\/32): jakarta-commons-discovery-0.4-5.4.el6.noarch.rpm                     |  73 kB     00:00<br \/>\n(9\/32): jakarta-commons-httpclient-3.1-0.6.el6.x86_64.rpm                    | 580 kB     00:00<br \/>\n(10\/32): jakarta-commons-logging-1.0.4-10.el6.noarch.rpm                     |  52 kB     00:00<br \/>\n(11\/32): java-1.5.0-gcj-1.5.0.0-29.1.el6.x86_64.rpm                          | 146 kB     00:00<br \/>\n(12\/32): java_cup-0.10k-5.el6.x86_64.rpm                                     | 197 kB     00:00<br \/>\n(13\/32): keyutils-libs-devel-1.4-1.el6.x86_64.rpm                            |  28 kB     00:00<br \/>\n(14\/32): krb5-devel-1.8.2-3.el6.x86_64.rpm                                   | 1.2 MB     00:00<br \/>\n(15\/32): libcom_err-devel-1.41.12-3.el6.x86_64.rpm                           |  30 kB     00:00<br \/>\n(16\/32): libgcj-4.4.4-13.el6.x86_64.rpm                                      |  19 MB     00:00<br \/>\n(17\/32): libselinux-devel-2.0.94-2.el6.x86_64.rpm                            | 135 kB     00:00<br \/>\n(18\/32): libsepol-devel-2.0.41-3.el6.x86_64.rpm                              |  64 kB     00:00<br \/>\n(19\/32): log4j-1.2.14-6.4.el6.x86_64.rpm                                     | 679 kB     00:00<br \/>\n(20\/32): mx4j-3.0.1-9.13.el6.noarch.rpm                                      | 1.1 MB     00:00<br \/>\n(21\/32): mysql-bench-5.1.47-4.el6.x86_64.rpm                                 | 426 kB     00:00<br \/>\n(22\/32): mysql-connector-java-5.1.12-2.el6.x86_64.rpm                        | 2.1 MB     00:00<br \/>\n(23\/32): mysql-connector-odbc-5.1.5r1144-7.el6.x86_64.rpm                    | 114 kB     00:00<br \/>\n(24\/32): mysql-devel-5.1.47-4.el6.x86_64.rpm                                 | 124 kB     00:00<br \/>\n(25\/32): mysql-test-5.1.47-4.el6.x86_64.rpm                                  | 4.9 MB     00:00<br \/>\n(26\/32): openssl-devel-1.0.0-4.el6.x86_64.rpm                                | 1.1 MB     00:00<br \/>\n(27\/32): regexp-1.5-4.4.el6.x86_64.rpm                                       | 105 kB     00:00<br \/>\n(28\/32): sinjdoc-0.5-9.1.el6.x86_64.rpm                                      | 705 kB     00:00<br \/>\n(29\/32): wsdl4j-1.5.2-7.8.el6.noarch.rpm                                     | 157 kB     00:00<br \/>\n(30\/32): xml-commons-apis-1.3.04-3.6.el6.x86_64.rpm                          | 439 kB     00:00<br \/>\n(31\/32): xml-commons-resolver-1.1-4.18.el6.x86_64.rpm                        | 145 kB     00:00<br \/>\n(32\/32): zlib-devel-1.2.3-25.el6.x86_64.rpm                                  |  43 kB     00:00<br \/>\n\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014-<br \/>\nTotal                                                                25 MB\/s |  37 MB     00:01<br \/>\nRunning rpm_check_debug<br \/>\nRunning Transaction Test<br \/>\nTransaction Test Succeeded<br \/>\nRunning Transaction<br \/>\nInstalling     : libgcj-4.4.4-13.el6.x86_64                                                  1\/32<br \/>\nInstalling     : jakarta-commons-logging-1.0.4-10.el6.noarch                                 2\/32<br \/>\nInstalling     : java-1.5.0-gcj-1.5.0.0-29.1.el6.x86_64                                      3\/32<br \/>\nInstalling     : 1:java_cup-0.10k-5.el6.x86_64                                               4\/32<br \/>\nInstalling     : sinjdoc-0.5-9.1.el6.x86_64                                                  5\/32<br \/>\nInstalling     : classpathx-jaf-1.0-15.4.el6.x86_64                                          6\/32<br \/>\nInstalling     : xml-commons-apis-1.3.04-3.6.el6.x86_64                                      7\/32<br \/>\nInstalling     : log4j-1.2.14-6.4.el6.x86_64                                                 8\/32<br \/>\nInstalling     : xml-commons-resolver-1.1-4.18.el6.x86_64                                    9\/32<br \/>\nInstalling     : regexp-1.5-4.4.el6.x86_64                                                  10\/32<br \/>\nInstalling     : bcel-5.2-7.2.el6.x86_64                                                    11\/32<br \/>\nInstalling     : 1:jakarta-commons-httpclient-3.1-0.6.el6.x86_64                            12\/32<br \/>\nInstalling     : classpathx-mail-1.1.1-9.4.el6.noarch                                       13\/32<br \/>\nInstalling     : wsdl4j-1.5.2-7.8.el6.noarch                                                14\/32<br \/>\nInstalling     : 1:jakarta-commons-discovery-0.4-5.4.el6.noarch                             15\/32<br \/>\nInstalling     : axis-1.2.1-7.2.el6.noarch                                                  16\/32<br \/>\nInstalling     : 1:mx4j-3.0.1-9.13.el6.noarch                                               17\/32<br \/>\nInstalling     : libcom_err-devel-1.41.12-3.el6.x86_64                                      18\/32<br \/>\nInstalling     : zlib-devel-1.2.3-25.el6.x86_64                                             19\/32<br \/>\nInstalling     : libsepol-devel-2.0.41-3.el6.x86_64                                         20\/32<br \/>\nInstalling     : libselinux-devel-2.0.94-2.el6.x86_64                                       21\/32<br \/>\nInstalling     : apache-tomcat-apis-0.1-1.el6.noarch                                        22\/32<br \/>\nInstalling     : geronimo-specs-1.0-3.4.M2.el6.noarch                                       23\/32<br \/>\nInstalling     : geronimo-specs-compat-1.0-3.4.M2.el6.noarch                                24\/32<br \/>\nInstalling     : keyutils-libs-devel-1.4-1.el6.x86_64                                       25\/32<br \/>\nInstalling     : krb5-devel-1.8.2-3.el6.x86_64                                              26\/32<br \/>\nInstalling     : 1:mysql-connector-java-5.1.12-2.el6.x86_64                                 27\/32<br \/>\nInstalling     : mysql-connector-odbc-5.1.5r1144-7.el6.x86_64                               28\/32<br \/>\nInstalling     : mysql-test-5.1.47-4.el6.x86_64                                             29\/32<br \/>\nInstalling     : openssl-devel-1.0.0-4.el6.x86_64                                           30\/32<br \/>\nInstalling     : mysql-devel-5.1.47-4.el6.x86_64                                            31\/32<br \/>\nInstalling     : mysql-bench-5.1.47-4.el6.x86_64                                            32\/32<br \/>\nInstalled:<br \/>\nmysql-bench.x86_64 0:5.1.47-4.el6                  mysql-connector-java.x86_64 1:5.1.12-2.el6<br \/>\nmysql-connector-odbc.x86_64 0:5.1.5r1144-7.el6     mysql-devel.x86_64 0:5.1.47-4.el6<br \/>\nmysql-test.x86_64 0:5.1.47-4.el6<\/p>\n<p style=\"text-align: justify;\">Dependency Installed:<br \/>\napache-tomcat-apis.noarch 0:0.1-1.el6             axis.noarch 0:1.2.1-7.2.el6<br \/>\nbcel.x86_64 0:5.2-7.2.el6                         classpathx-jaf.x86_64 0:1.0-15.4.el6<br \/>\nclasspathx-mail.noarch 0:1.1.1-9.4.el6            geronimo-specs.noarch 0:1.0-3.4.M2.el6<br \/>\ngeronimo-specs-compat.noarch 0:1.0-3.4.M2.el6     jakarta-commons-discovery.noarch 1:0.4-5.4.el6<br \/>\njakarta-commons-httpclient.x86_64 1:3.1-0.6.el6   jakarta-commons-logging.noarch 0:1.0.4-10.el6<br \/>\njava-1.5.0-gcj.x86_64 0:1.5.0.0-29.1.el6          java_cup.x86_64 1:0.10k-5.el6<br \/>\nkeyutils-libs-devel.x86_64 0:1.4-1.el6            krb5-devel.x86_64 0:1.8.2-3.el6<br \/>\nlibcom_err-devel.x86_64 0:1.41.12-3.el6           libgcj.x86_64 0:4.4.4-13.el6<br \/>\nlibselinux-devel.x86_64 0:2.0.94-2.el6            libsepol-devel.x86_64 0:2.0.41-3.el6<br \/>\nlog4j.x86_64 0:1.2.14-6.4.el6                     mx4j.noarch 1:3.0.1-9.13.el6<br \/>\nopenssl-devel.x86_64 0:1.0.0-4.el6                regexp.x86_64 0:1.5-4.4.el6<br \/>\nsinjdoc.x86_64 0:0.5-9.1.el6                      wsdl4j.noarch 0:1.5.2-7.8.el6<br \/>\nxml-commons-apis.x86_64 0:1.3.04-3.6.el6          xml-commons-resolver.x86_64 0:1.1-4.18.el6<br \/>\nzlib-devel.x86_64 0:1.2.3-25.el6<\/p>\n<p style=\"text-align: justify;\">Complete!<\/p>\n<p style=\"text-align: justify;\"><strong>[root@www ~]#<\/strong> rpm  -qa | grep php-mysql<br \/>\nphp-mysql-5.3.2-6.el6.x86_64<\/p>\n<p style=\"text-align: justify;\">(if no output comes then #yum install php-mysql)<\/p>\n<p style=\"text-align: justify;\"><strong>[root@www ~]#<\/strong> service mysqld restart<br \/>\nStopping mysqld:                                           [  OK  ]<br \/>\nInitializing MySQL database:  Installing MySQL system tables\u2026  OK<br \/>\nFilling help tables\u2026  OK<\/p>\n<p style=\"text-align: justify;\">To start mysqld at boot time you have to copy<br \/>\nsupport-files\/mysql.server to the right place for your system<\/p>\n<p style=\"text-align: justify;\">PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !<br \/>\nTo do so, start the server, then issue the following commands:<\/p>\n<p style=\"text-align: justify;\">\/usr\/bin\/mysqladmin -u root password \u2018new-password\u2019<br \/>\n\/usr\/bin\/mysqladmin -u root -h <a href=\"http:\/\/www.mc712.com\" rel=\"nofollow\">http:\/\/www.mc712.com<\/a> password \u2018new-password\u2019<\/p>\n<p style=\"text-align: justify;\">Alternatively you can run:<br \/>\n\/usr\/bin\/mysql_secure_installation<\/p>\n<p style=\"text-align: justify;\">which will also give you the option of removing the test<br \/>\ndatabases and anonymous user created by default.  This is<br \/>\nstrongly recommended for production servers.<\/p>\n<p style=\"text-align: justify;\">See the manual for more instructions.<\/p>\n<p style=\"text-align: justify;\">You can start the MySQL daemon with:<br \/>\ncd \/usr ; \/usr\/bin\/mysqld_safe &amp;<\/p>\n<p style=\"text-align: justify;\">You can test the MySQL daemon with mysql-test-run.pl<br \/>\ncd \/usr\/mysql-test ; perl mysql-test-run.pl<\/p>\n<p style=\"text-align: justify;\">Please report any problems with the \/usr\/bin\/mysqlbug script!<\/p>\n<p style=\"text-align: justify;\">[  OK  ]<br \/>\nStarting mysqld:                                           [  OK  ]<\/p>\n<p style=\"text-align: justify;\">[root@www ~]# \/usr\/bin\/mysqladmin -u root password \u2018redhat6\u2032<\/p>\n<p style=\"text-align: justify;\">redhat6 is a new password<\/p>\n<p style=\"text-align: justify;\"><strong>[root@www ~]#<\/strong> mysql -u root -p<br \/>\nEnter password: redhat6<br \/>\nWelcome to the MySQL monitor.  Commands end with ; or g.<br \/>\nYour MySQL connection id is 3<br \/>\nServer version: 5.1.47 Source distribution<\/p>\n<p style=\"text-align: justify;\">Copyright (c) 2000, 2010, Oracle and\/or its affiliates. All rights reserved.<br \/>\nThis software comes with ABSOLUTELY NO WARRANTY. This is free software,<br \/>\nand you are welcome to modify and redistribute it under the GPL v2 license<\/p>\n<p style=\"text-align: justify;\">Type \u2018help;\u2019 or \u2018h\u2019 for help. Type \u2018c\u2019 to clear the current input statement.<\/p>\n<p style=\"text-align: justify;\">mysql&gt;<br \/>\n<strong>mysql&gt;<\/strong> show databases;<br \/>\n+\u2014\u2014\u2014\u2014\u2014\u2014\u2013+<br \/>\n| Database           |<br \/>\n+\u2014\u2014\u2014\u2014\u2014\u2014\u2013+<br \/>\n| information_schema |<br \/>\n| mysql              |<br \/>\n| test               |<br \/>\n+\u2014\u2014\u2014\u2014\u2014\u2014\u2013+<br \/>\n3 rows in set (1.32 sec)<\/p>\n<p style=\"text-align: justify;\"><strong>mysql&gt;<\/strong> create user mc712@localhost IDENTIFIED BY \u201credhat6\u2033;<br \/>\nQuery OK, 0 rows affected (0.56 sec)<\/p>\n<p style=\"text-align: justify;\"><strong>mysql&gt;<\/strong> create database mc712database;<br \/>\nQuery OK, 1 row affected (0.12 sec)<\/p>\n<p style=\"text-align: justify;\"><strong>mysql&gt;<\/strong> GRANT ALL ON mc712database.* To mc712@localhost;<br \/>\nQuery OK, 0 rows affected (0.00 sec)<\/p>\n<p style=\"text-align: justify;\"><strong>mysql&gt;<\/strong> GRANT ALL ON *.* To mc712@localhost;<br \/>\nQuery OK, 0 rows affected (0.00 sec)<\/p>\n<p style=\"text-align: justify;\"><strong>mysql&gt;<\/strong> exit<br \/>\nBye<\/p>\n<\/div>\n<p style=\"text-align: justify;\">\n<p style=\"text-align: justify;\">\n<p style=\"text-align: justify;\">\n<p style=\"text-align: justify;\">\n<p style=\"text-align: justify;\">\n","protected":false},"excerpt":{"rendered":"<p>[root@www ~]# yum install mysql* Loaded plugins: refresh-packagekit, rhnplugin This system is not registered with RHN. RHN support will be disabled. Setting up Install Process<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"class_list":["post-116","post","type-post","status-publish","format-standard","hentry","category-redhat-linux-operating-system"],"_links":{"self":[{"href":"http:\/\/www.mandcgroup.in\/blog\/wp-json\/wp\/v2\/posts\/116","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.mandcgroup.in\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.mandcgroup.in\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.mandcgroup.in\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.mandcgroup.in\/blog\/wp-json\/wp\/v2\/comments?post=116"}],"version-history":[{"count":2,"href":"http:\/\/www.mandcgroup.in\/blog\/wp-json\/wp\/v2\/posts\/116\/revisions"}],"predecessor-version":[{"id":118,"href":"http:\/\/www.mandcgroup.in\/blog\/wp-json\/wp\/v2\/posts\/116\/revisions\/118"}],"wp:attachment":[{"href":"http:\/\/www.mandcgroup.in\/blog\/wp-json\/wp\/v2\/media?parent=116"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.mandcgroup.in\/blog\/wp-json\/wp\/v2\/categories?post=116"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.mandcgroup.in\/blog\/wp-json\/wp\/v2\/tags?post=116"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}