ITPub博客

1.mysql source code install(5.7.15)mysql版本相关知识mysql的命名机制使用3个数字和一个后最组成的版本号mysql-5.0.0-beta  5表示主版本号,0表示级别，9表示发行系列的版本号 alpha -有未被测试的新代码 beta  -alpha版使用一个月之后没有致命漏洞 rc    -发行了一段时间...

C:\Users\admin>mysql -h localhost -uroot -pmysql mysql: [Warning] Using a password on thecommand line interface can be insecure. Welcome to the MySQL monitor.  Commands end with ; or \g. Your MySQL connection id is 4 Server version: 5.7.14 MySQL CommunityServer (GPL) &n...

4.1 create and drop databaseC:\Users\admin>mysql -h localhost -u root -pmysqlmysql: [Warning] Using a password on thecommand line interface can be insecure.Welcome to the MySQL monitor.  Commands end with ; or \g.Your MySQL connection id is 3Server version: 5.7.14 My...

3.1 整数类型整数类型字节数无符合数的取值范围有符合数的取值范围TINYINT10~255-128~127...

http://dev.mysql.com/downloads/mysql/   下载地址,在下拉框中选择相应的版本windows下直接双击下载文件安装吧直接上图吧  本地连接测试一下.E:\mysql\bin>mysql -h 172.16.20.31 -uroot -pEnter password: *****ERROR 1130 ...

1.1    下载http://dev.mysql.com/downloads/mysql/   下载地址,在下拉框中选择相应的版本 1.2    安装下载下来的绿色安装包，直接解压为E:\mysql 1.3    编辑my.ini文件，将mydefault.ini copy一份出来，就该其中的参数....

获得 mysql帮助[@more@]mysql> help contents; ? contentsYou asked for help about help category: "Contents"For more information, type 'help <item>', where <item> is one of the followingcategories: Account Management Administration Compound Statements Data Definition Data Manipulation Data Types Functions Functions and Modifiers for Use with GROUP BY Geographic Features Help Metadata Language Structure Plugins Procedures Storage Engines Tab

Mysql多数据库启动方法[@more@]Mysqld_multiMysqld_multi is designed to manage several mysqld processes that listen for connection on different unix socket files and tcp/ip ports. It can start or stop servers,or report their current status,The mysql instance manager is an alternative means of managing multiple servers[root@oracle mysql5168]# mkdir data2[root@oracle mysql5168]# mkdir data3[root@oracle mysql5168]# chown -R mysql:mysql data[root@oracle mysql5168]# chown -R mysql:mysql data2[root@oracl

1,mysqld[@more@] Mysqld is the mysql server Mysql read options from the [mysqld] and [server] groups 直接调用的话，error message会定位到终端，不会到日志[root@oracle bin]# ./mysqladmin shutdown[root@oracle bin]# ps -ef | grep mysqlroot 14146 13810 0 07:02 pts/3 00:00:00 grep mysql[root@oracle bin]# cd ../libexec/[root@oracle libexec]# pwd/u02/mysql5168/libexec[root@oracle libexec]# ./mysqld --defaults-file=/u02/my.cnf --user=mysql130224 7:03:40 [Warning] '--skip-locking' is deprecated an

今天测试了一下mysql-5.1.68源码安装,具体步骤如下:[@more@]tar.gz 结尾的, 解压之后的目录中：Build 目录：各种平台的编译脚本，监测 cpu型号的编译脚本 Check-cpu脚本Client :客户端程序的源代码 , mysql.cc,mysqladmin.ccDocs:Storage :存储引擎目录，实现了 handerMysys: :mysql 为了实现跨平台对系统库封装Sql: 数据库主程序目录，存储引擎接口。Vio: 封装了各种协议的网络操作Limysqld： mysql链接库的源代码源码安装中 configure的作用, 有检查c的编译器，生产 makefile文件Configure的常用选项：--prefix 设

今天测试了一下mysql 5.6.10的源码安装，具体步骤如下：[@more@] 1,安装mysql 5.6.10之前，有几个包是必须的. gcc,bison,readline,cmake,其中cmake 的安装如下,先下载cmake-2.8.10.2.tar.gztar -zxvf cmake-2.8.10.2.tar.gzcd cmake-2.8.10.2./bootstrapgmakegmake install 2,切换到mysql 5.6.10解压目录groupadd mysqluseradd -g mysql mysql tar -zxvf mysql-5.6.10.tar.gzcd mysql-5.6.10cmake .makemake install --cmake . -DCMAKE_INSTALL_PREFIX=/u01/mysql5610 -DMYSQL_DATADIR=/u01/data -DWITH_INNOBASE_STORAGE_EN