{"id":444,"date":"2014-01-22T16:36:07","date_gmt":"2014-01-22T13:06:07","guid":{"rendered":"http:\/\/irwebhost.com\/blog\/?p=444"},"modified":"2014-09-23T11:59:08","modified_gmt":"2014-09-23T08:29:08","slug":"%d9%86%d8%b5%d8%a8-%d8%af%db%8c%d8%aa%d8%a7%d8%a8%db%8c%d8%b3-mysql","status":"publish","type":"post","link":"https:\/\/www.irwebhost.com\/blog\/%d9%86%d8%b5%d8%a8-%d8%af%db%8c%d8%aa%d8%a7%d8%a8%db%8c%d8%b3-mysql\/","title":{"rendered":"\u0646\u0635\u0628 \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 MYSQL"},"content":{"rendered":"

\u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 \u0633\u0631\u0648\u0631 mysql\u00a0 \u06cc\u06a9 \u0633\u06cc\u0633\u062a\u0645 \u0628\u0627\u0646\u06a9 \u0627\u0637\u0644\u0627\u0639\u0627\u062a\u06cc \u0627\u0631\u062a\u0628\u0627\u0637\u06cc \u0627\u0633\u062a.
\nrelational database management system RDBMS<\/p>\n

\u0627\u0645\u06a9\u0627\u0646 \u0627\u0631\u062a\u0628\u0627\u0637 \u0686\u0646\u062f\u06cc\u0646 \u06a9\u0627\u0631\u0628\u0631 \u0628\u0647 \u0627\u06cc\u0646 \u0628\u0627\u0646\u06a9 \u0627\u0637\u0644\u0627\u0639\u0627\u062a\u06cc \u0628\u0631 \u0631\u0648\u06cc \u0633\u0631\u0648\u0631 \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f. \u062f\u0631 \u0627\u06cc\u0646 \u0645\u0642\u0627\u0644\u0647 \u0646\u0635\u0628 \u0627\u06cc\u0646 \u0628\u0631\u0646\u0627\u0645\u0647 \u0628\u0631 \u0631\u0648\u06cc \u0633\u0631\u0648\u0631\u0647\u0627\u06cc \u0632\u06cc\u0631 \u0631\u0627 \u062a\u0648\u0636\u06cc\u062d \u0645\u06cc\u062f\u0647\u06cc\u0645 :<\/p>\n

MYSQL version 5.5.33<\/strong><\/p>\n

Fedora 18\/17\/16\/15\/14\/13\/12
\nCentOS 6.4\/6.3\/6.2\/6.1\/6\/5.9
\nRed Hat (RHEL) 6.4\/6.3\/6.2\/6.1\/6\/5.9<\/p>\n

Change root user<\/h3>\n

<\/p>\n

su –
\n## OR ##
\nsudo -i<\/p><\/blockquote>\n

 <\/p>\n

Install Remi repositoryFedora<\/h3>\n

## Remi Dependency on Fedora 18, 17, 16
\nrpm -Uvh http:\/\/download1.rpmfusion.org\/free\/fedora\/rpmfusion-free-release-stable.noarch.rpm<\/p>\n

 <\/p>\n

rpm -Uvh http:\/\/download1.rpmfusion.org\/nonfree\/fedora\/rpmfusion-nonfree-release-stable.noarch.rpm<\/p>\n

 <\/p>\n

 <\/p>\n

## Fedora 18 ##
\nrpm -Uvh http:\/\/rpms.famillecollet.com\/remi-release-18.rpm<\/p>\n

 <\/p>\n

 <\/p>\n

## Fedora 17 ##
\nrpm -Uvh http:\/\/rpms.famillecollet.com\/remi-release-17.rpm<\/p>\n

 <\/p>\n

 <\/p>\n

## Fedora 16 ##
\nrpm -Uvh http:\/\/rpms.famillecollet.com\/remi-release-16.rpm<\/p>\n

 <\/p>\n

 <\/p>\n

## Fedora 15 ##
\nrpm -Uvh http:\/\/rpms.famillecollet.com\/remi-release-15.rpm<\/p>\n

 <\/p>\n

 <\/p>\n

## Fedora 14 ##
\nrpm -Uvh http:\/\/rpms.famillecollet.com\/remi-release-14.rpm<\/p>\n

 <\/p>\n

 <\/p>\n

## Fedora 13 ##
\nrpm -Uvh http:\/\/rpms.famillecollet.com\/remi-release-13.rpm<\/p>\n

 <\/p>\n

 <\/p>\n

## Fedora 12 ##
\nrpm -Uvh http:\/\/rpms.famillecollet.com\/remi-release-12.rpm<\/p>\n

 <\/p>\n

 <\/p><\/blockquote>\n

\u00a0CentOS and Red Hat (RHEL)<\/p>\n

\n

<\/h4>\n

## Remi Dependency on CentOS 6 and Red Hat (RHEL) 6 ##
\nrpm -Uvh http:\/\/download.fedoraproject.org\/pub\/epel\/6\/i386\/epel-release-6-8.noarch.rpm<\/p>\n

## CentOS 6 and Red Hat (RHEL) 6 ##
\nrpm -Uvh http:\/\/rpms.famillecollet.com\/enterprise\/remi-release-6.rpm<\/p>\n

 <\/p>\n

 <\/p>\n

## Remi Dependency on CentOS 5 and Red Hat (RHEL) 5 ##
\nrpm -Uvh http:\/\/dl.fedoraproject.org\/pub\/epel\/5\/i386\/epel-release-5-4.noarch.rpm<\/p>\n

 <\/p>\n

 <\/p>\n

## CentOS 5 and Red Hat (RHEL) 5 ##
\nrpm -Uvh http:\/\/rpms.famillecollet.com\/enterprise\/remi-release-5.rpm<\/p>\n

 <\/p>\n

 <\/p><\/blockquote>\n

Check Available MySQL versions<\/h3>\n

Fedora 18, 17, 16, 15, 14, 13, 12<\/h4>\n

 <\/p>\n

yum –enablerepo=remi list mysql mysql-server<\/p><\/blockquote>\n

 <\/p>\n

CentOS 6.4\/6.3\/6.2\/6.1\/6\/5.9 and Red Hat (RHEL) 6.4\/6.3\/6.2\/6.1\/6\/5.9<\/h4>\n

 <\/p>\n

yum –enablerepo=remi,remi-test list mysql mysql-server<\/p>\n

 <\/p><\/blockquote>\n

Output:<\/p>\n

\n

Loaded plugins: changelog, fastestmirror, presto, refresh-packagekit
\n…
\nremi\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | 3.0 kB\u00a0\u00a0\u00a0\u00a0 00:00
\nremi\/primary_db\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | 106 kB\u00a0\u00a0\u00a0\u00a0 00:00
\nAvailable Packages
\nmysql.i686\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 5.5.33-1.fc18.remi\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 @remi
\nmysql-server.i686\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 5.5.33-1.fc18.remi\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 @remi<\/p>\n<\/blockquote>\n

Update or Install MySQL 5.5.33<\/h3>\n

Fedora 18, 17, 16, 15, 14, 13, 12<\/h4>\n

 <\/p>\n

yum –enablerepo=remi install mysql mysql-server<\/p>\n

 <\/p><\/blockquote>\n

CentOS 6.4\/6.3\/6.2\/6.1\/6\/5.9 and Red Hat (RHEL) 6.4\/6.3\/6.2\/6.1\/6\/5.9<\/h4>\n

yum –enablerepo=remi,remi-test install mysql mysql-server<\/p><\/blockquote>\n

Start MySQL server and autostart MySQL on boot<\/h3>\n

Fedora 18\/17\/16<\/h4>\n

systemctl start mysqld.service ## use restart after update<\/p>\n

systemctl enable mysqld.service<\/p><\/blockquote>\n

Fedora 15\/14\/13\/12\/11, CentOS 6.4\/6.3\/6.2\/6.1\/6\/5.9 and Red Hat (RHEL) 6.4\/6.3\/6.2\/6.1\/6\/5.9<\/h4>\n

\/etc\/init.d\/mysqld start ## use restart after update
\n## OR ##
\nservice mysqld start ## use restart after update<\/p>\n

chkconfig –levels 235 mysqld on<\/p><\/blockquote>\n

MySQL Secure Installation<\/h3>\n

Start MySQL Secure Installation with following command<\/h4>\n

 <\/p>\n

\n

\/usr\/bin\/mysql_secure_installation<\/p>\n<\/blockquote>\n

\n

NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MySQL
\nSERVERS IN PRODUCTION USE!\u00a0 PLEASE READ EACH STEP CAREFULLY!<\/p>\n

In order to log into MySQL to secure it, we\\’ll need the current
\npassword for the root user.\u00a0 If you\\’ve just installed MySQL, and
\nyou haven\\’t set the root password yet, the password will be blank,
\nso you should just press enter here.<\/p>\n

Enter current password for root (enter for none):
\nOK, successfully used password, moving on…<\/p>\n

Setting the root password ensures that nobody can log into the MySQL
\nroot user without the proper authorisation.<\/p>\n

Set root password? [Y\/n] Y
\nNew password:
\nRe-enter new password:
\nPassword updated successfully!
\nReloading privilege tables..
\n… Success!<\/p>\n

By default, a MySQL installation has an anonymous user, allowing anyone
\nto log into MySQL without having to have a user account created for
\nthem.\u00a0 This is intended only for testing, and to make the installation
\ngo a bit smoother.\u00a0 You should remove them before moving into a
\nproduction environment.<\/p>\n

Remove anonymous users? [Y\/n] Y
\n… Success!<\/p>\n

Normally, root should only be allowed to connect from ‘localhost’.\u00a0 This
\nensures that someone cannot guess at the root password from the network.<\/p>\n

Disallow root login remotely? [Y\/n] Y
\n… Success!<\/p>\n

By default, MySQL comes with a database named ‘test’ that anyone can
\naccess.\u00a0 This is also intended only for testing, and should be removed
\nbefore moving into a production environment.<\/p>\n

Remove test database and access to it? [Y\/n] Y
\n– Dropping test database…
\n… Success!
\n– Removing privileges on test database…
\n… Success!<\/p>\n

Reloading the privilege tables will ensure that all changes made so far
\nwill take effect immediately.<\/p>\n

Reload privilege tables now? [Y\/n] Y
\n… Success!<\/p>\n

Cleaning up…<\/p>\n

All done!\u00a0 If you\\’ve completed all of the above steps, your MySQL
\ninstallation should now be secure.<\/p>\n

Thanks for using MySQL!<\/p>\n

\n<\/blockquote>\n

\n

mysqladmin -u root password [your_password_here]<\/p>\n

## Example ##
\nmysqladmin -u root password myownsecrectpass<\/p><\/blockquote>\n

Connect to MySQL database (localhost) with password<\/h3>\n

mysql -u root -p<\/p>\n

## OR ##
\nmysql -h localhost -u root -p<\/p><\/blockquote>\n

Create Database, Create MySQL User and Enable Remote Connections to MySQL Database<\/h3>\n
    \n
  • DB_NAME = webdb<\/li>\n
  • USER_NAME = webdb_user<\/li>\n
  • REMOTE_IP = 10.0.15.25<\/li>\n
  • PASSWORD = password123<\/li>\n
  • PERMISSIONS = ALL<\/li>\n<\/ul>\n

    ## CREATE DATABASE ##
    \nmysql> CREATE DATABASE webdb;<\/p>\n

    ## CREATE USER ##
    \nmysql> CREATE USER ‘webdb_user’@’10.0.15.25’ IDENTIFIED BY ‘password123’;<\/p>\n

    ## GRANT PERMISSIONS ##
    \nmysql> GRANT ALL ON webdb.* TO ‘webdb_user’@’10.0.15.25’;<\/p>\n

    ##\u00a0 FLUSH PRIVILEGES, Tell the server TO reload the GRANT TABLES\u00a0 ##
    \nmysql> FLUSH PRIVILEGES;<\/p>\n

     <\/p><\/blockquote>\n

    Enable Remote Connection to MySQL Server \u2013> Open MySQL Port (3306) on Iptables Firewall (as root user again)<\/h2>\n

    nano -w \/etc\/sysconfig\/iptables
    \n-A INPUT -m state –state NEW -m tcp -p tcp –dport 3306 -j ACCEPT<\/p>\n

     <\/p>\n

    service iptables restart<\/p>\n

     <\/p>\n

    ## OR ##
    \n\/etc\/init.d\/iptables restart\/<\/p>\n

     <\/p>\n

    mysql -h dbserver_name_or_ip_address -u<\/p>\n

     <\/p>\n

    webdb_user -p webdb<\/p>\n

     <\/p><\/blockquote>\n","protected":false},"excerpt":{"rendered":"

    \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 \u0633\u0631\u0648\u0631 mysql\u00a0 \u06cc\u06a9 \u0633\u06cc\u0633\u062a\u0645 \u0628\u0627\u0646\u06a9 \u0627\u0637\u0644\u0627\u0639\u0627\u062a\u06cc \u0627\u0631\u062a\u0628\u0627\u0637\u06cc \u0627\u0633\u062a. relational database management system RDBMS \u0627\u0645\u06a9\u0627\u0646 \u0627\u0631\u062a\u0628\u0627\u0637 \u0686\u0646\u062f\u06cc\u0646 \u06a9\u0627\u0631\u0628\u0631 \u0628\u0647 \u0627\u06cc\u0646 \u0628\u0627\u0646\u06a9 \u0627\u0637\u0644\u0627\u0639\u0627\u062a\u06cc \u0628\u0631 \u0631\u0648\u06cc \u0633\u0631\u0648\u0631 \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f. \u062f\u0631 \u0627\u06cc\u0646 \u0645\u0642\u0627\u0644\u0647 \u0646\u0635\u0628 \u0627\u06cc\u0646 \u0628\u0631\u0646\u0627\u0645\u0647 \u0628\u0631 \u0631\u0648\u06cc \u0633\u0631\u0648\u0631\u0647\u0627\u06cc \u0632\u06cc\u0631 \u0631\u0627 \u062a\u0648\u0636\u06cc\u062d \u0645\u06cc\u062f\u0647\u06cc\u0645 : MYSQL version 5.5.33 Fedora 18\/17\/16\/15\/14\/13\/12 CentOS 6.4\/6.3\/6.2\/6.1\/6\/5.9 Red Hat (RHEL) 6.4\/6.3\/6.2\/6.1\/6\/5.9 Change root user<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6,5,11],"tags":[],"class_list":["post-444","post","type-post","status-publish","format-standard","hentry","category-dedicated-servers","category-vps","category-11"],"_links":{"self":[{"href":"https:\/\/www.irwebhost.com\/blog\/wp-json\/wp\/v2\/posts\/444","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.irwebhost.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.irwebhost.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.irwebhost.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.irwebhost.com\/blog\/wp-json\/wp\/v2\/comments?post=444"}],"version-history":[{"count":22,"href":"https:\/\/www.irwebhost.com\/blog\/wp-json\/wp\/v2\/posts\/444\/revisions"}],"predecessor-version":[{"id":751,"href":"https:\/\/www.irwebhost.com\/blog\/wp-json\/wp\/v2\/posts\/444\/revisions\/751"}],"wp:attachment":[{"href":"https:\/\/www.irwebhost.com\/blog\/wp-json\/wp\/v2\/media?parent=444"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.irwebhost.com\/blog\/wp-json\/wp\/v2\/categories?post=444"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.irwebhost.com\/blog\/wp-json\/wp\/v2\/tags?post=444"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}