MySQL Concept
文章平均质量分 82
songyb
这个作者很懒,什么都没留下…
展开
-
Done with "file /usr/share/mysql/czech/errmsg.sys from install of mysql-community-common-5.7.9-1.el6
安装时报如下错误:[root@mysql tmp]# rpm -ivh mysql-community-server-5.7.9-1.el6.x86_64.rpm warning: mysql-community-server-5.7.9-1.el6.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEYerror:原创 2017-06-21 23:29:48 · 3434 阅读 · 1 评论 -
MySQL学习笔记2-System administration(set password)II
发现在5.7.18版本中,不能按照前面说的修改密码,可以按照下面的操作修改:在第一个窗口执行:[root@mysql mysql]# service mysqld stopStopping mysqld: [ OK ][root@mysql mysql]# /usr/bin/mysqld原创 2017-06-21 23:24:16 · 445 阅读 · 0 评论 -
How to Set Up Replication--MySQL Concept
Thissection describes how to set up complete replication of a MySQL server. Thereare a number of different methods for setting up replication, and the exact methodto use depends on how you are setting原创 2016-01-14 18:47:57 · 770 阅读 · 0 评论 -
Using Option Files --MySQL Concept
Using Option FilesMostMySQL programs can read startup options from option files (also sometimescalled configuration files). Option files provide a convenient way to specifycommonly used options so t原创 2016-01-11 18:29:49 · 514 阅读 · 0 评论 -
MySQL学习笔记-04_Server_Config(mysqld --verbose --help)
[root@songyb usr]# mysqld --verbose --help2015-11-11 17:32:14 0 [Note] mysqld (mysqld 5.6.27) starting as process 4699 ...2015-11-11 17:32:14 4699 [Note] Plugin 'FEDERATED' is disabled.mysqld V原创 2015-11-19 20:52:19 · 2239 阅读 · 0 评论 -
MySQL学习笔记-04_Server_Config
Server ConfigurationMySQL Configuration OptionsYou can specify startup options on the command line when you invoke the server (or client), or in an option file. MySQL client programs look for op原创 2015-11-19 20:50:56 · 576 阅读 · 0 评论 -
MySQL学习笔记2-System administration(uninstall mysql)
1、查找以前是否装有mysql命令:rpm -qa|grep -i mysql可以看到mysql的两个包:[root@localhost init.d]# rpm -qa | grep -i mysqlMySQL-server-5.6.27-1.el6.i686MySQL-client-5.6.27-1.el6.i6862、删除mysql删除命令:rpm -e原创 2015-11-17 14:28:27 · 404 阅读 · 0 评论 -
MySQL学习笔记2-System administration(set password)
安装完毕后,第一次登录mysql,修改密码[root@localhost bin]# service mysql startStarting MySQL.. SUCCESS! [root@localhost bin]# cat /root/.mysql_secret# The random password set for the root user at Tue Nov 17原创 2015-11-17 15:51:32 · 654 阅读 · 0 评论 -
MySQL学习笔记2-System administration(STOP or START MySQL)
START MYSQL[root@localhost bin]# service mysql startStarting MySQL.. SUCCESS! [root@localhost bin]# ps -ef | grep mysqlroot 5548 1 0 22:00 pts/2 00:00:00 /bin/sh /usr/bin/mysqld_s原创 2015-11-17 15:49:31 · 434 阅读 · 0 评论 -
MySQL学习笔记2-System administration(Installing MySQL on Linux Using RPM Packages)
2.5.5 Installing MySQL on Linux Using RPM PackagesNoteTo install or upgrade to MySQL 5.7.2 or later, be sure to read the special instructions at the end of this section.The rec原创 2015-11-11 19:55:59 · 649 阅读 · 0 评论 -
MySQL学习笔记2-System administration
System administration=======================MySQL Server DistributionsMySQL is available for several operating systems, including Linux, Windows, Mac OS X, and Oracle SolarisMySQL is a原创 2015-11-11 16:20:55 · 580 阅读 · 0 评论 -
MySQL学习笔记1-MySQL Architecture
ArchitectureNote the difference between a server and a host:o Server: A software program (mysqld) with a version number and a list of featureso Host: The physical machine on which the server progr原创 2015-11-10 20:23:54 · 616 阅读 · 0 评论