mysqlµÄÅäÖÃÎļþmy.ini
# MySQL Server Instance Configuration File
# ----------------------------------------------------------------------
# Generated by the MySQL Server Instance Configuration Wizard
#
#
# Installation Instructions
# ----------------------------------------------------------------------
#
# On Linux you can copy this file to /etc/my.cnf to set global options,
# mysql-data-dir/my.cnf to set server-specific options
# (@localstatedir@ for this installation) or to
# ~/.my.cnf to set user-specific options.
#
# On Windows you should keep this file in the installation directory
# of your server (e.g. C:\Program Files\MySQL\MySQL Server X.Y). To
# make sure the server reads the config file use the startup option
# "--defaults-file".
#
# To run run the server from the command line, execute this in a
# command line shell, e.g.
# mysqld --defaults-file="C:\Program Files\MySQL\MySQL Server X.Y\my.ini"
#
# To install the server as a Windows service manually, execute this in a
# command line shell, e.g.
# mysqld --install MySQLXY --defaults-file="C:\Program Files\MySQL\MySQL Server X.Y\my.ini"
#
# And then execute this in a command line shell to start the server, e.g.
# net start MySQLXY
#
#
# Guildlines for editing this file
# ----------------------------------------------------------------------
#
# In this file, you can use all long options that the program supports.
# If you want to know the options a program supports, start the program
# with the "--help" option.
#
# More detailed information about the individual options can also be
# found in the manual.
#
#
# CLIENT SECTION
# ----------------------------------------------------------------------
#
# The following options will be read by MySQL client applications.
# Note that only client applications shipped by MySQL are guaranteed
# to read this section. If you want your own MySQL client program to
# honor these values, you need to speci
Ïà¹ØÎĵµ£º
Ò»£® ½¨±íÓë³õʼ»¯Êý¾Ý
ÔÚmysqlµÄtestÊý¾Ý¿âÖн¨Á¢Ò»ÕÅÐÂ±í£ºtbl_user,½¨±íÓï¾äÈçÏ£º
DROP TABLE IF EXISTS `user`;
CREATE TABLE `tbl_user` (
`userid` varchar(50) NOT NULL,
`name` varchar(50) default '',
`blog` varchar(50) default '',
  ......
ÒÔÏÂÕª×ÔÍøÂç
----------------------------------------
½ñÌìÔÚÓÃÔ¶³ÌÁ¬½ÓMysql·þÎñÆ÷µÄÊý¾Ý¿â£¬²»¹ÜÔõôŪ¶¼ÊÇÁ¬½Ó²»µ½£¬´íÎó´úÂëÊÇ1130£¬ERROR 1130: Host 192.168.2.159 is not allowed to connect to this MySQL server
²ÂÏëÊÇÎÞ·¨¸øÔ¶³ÌÁ¬½ÓµÄÓû§È¨ÏÞÎÊÌâ¡£½á¹ûÕâÑù×Ó²Ù×÷mysql¿â£¬¼´¿É½â¾ö¡£ÔÚ±¾»úµÇÈëmysqlº ......
ÔÚа²×°ºÃµÄmysql £¬apahce£¬php µÄʱºò£¬Èç¹ûÔÚ´úÂëÖÐʹÓÃÁËsessions_start() µÄʱºò»á³öÏÖÀàËÆÒÔϵĴíÎó£º
Warning: session_start() [function.session-start]: Cannot send session cooki µÈµÄ´íÎó¡£
Çë°²×°ÈçϵÄ˼·ȥÐÞÕý£º
1.ÔÚphp.ini ÖÐÅäÖÃ session.savepath='/tmp'
2.¿ªÆôsession.auto_start=1
3.°Ñ¸ü¸Ä ......
ÔÚUbuntuϰ²×°µÄMySQLĬÈÏÅäÖÃϵÄÊý¾Ý¿âÎļþ´æ´¢Î»ÖÃÊÇÔÚ/var/lib/mysql£¬
MySQLÊý¾Ý¿âµÄÎļþ½á¹¹ÊÇÔõôÑùµÄÄØ£¬¶ÔÓÚÕâÑù×Ó´´½¨µÄÊý¾Ý¿âÃüÁ
¡¡¡¡CREATE¡¡DATABASE¡¡mysqldb
¡¡¡¡ÔÚĬÈϵÄÊý¾Ý¿â´æ´¢Î»ÖÃϾͻáÓиöÎļþ¼Ðmysqldb¡£Òª²Ù×÷Êý¾Ý¿âÊ×ÏȵÃÍ£Ö¹Êý¾Ý¿â½ø³Ì£º
¡¡¡¡$sudo¡¡/etc/init.d/mysql¡¡stop
±¾ÎÄÒÔת ......
MysqlµÄ×Ö·û¼¯ÊDZȽÏÂé·³µÄ,ĬÈϵĶÔÎÒÃÇÀ´Ëµ¸ù±¾¾ÍûʲôÓÃ,ÎÒÃÇÊÇÒªÓõ½ÖÐÎĵÄ,ËùÒÔÒ»¶¨µÃ¸Ä×Ö·û¼¯,Èç¹û×Ö·û¼¯²»¶Ô»áÓкܶàµÄÎÊÌâ,ÓÐÂÒÂ뻹ÓоÍÊÇÎÒÃÇÔÚ³ÌÐòÀï²åÈëÖÐÎÄʱ»á¸øÄã˵mysql Data truncation: Data too long for column,ÄãǧÍò±ðÒÔΪÊÇÄãµÄ×Ö¶ÎÉèµÃ²»¹»³¤,ÄãÉèµÃÔÙ³¤Ëû¶¼»á±¨´í,ËùÒÔ¸Ä×Ö·û¼¯°É
ÎÒÃÇÒ»°ã×°ºÃÊý ......