a later version of mysql（mysql 我用set global variable=32*1024*1024； 后在查看variable的值没有变化，这是为什么）
本文目录
- mysql 我用set global variable=32*1024*1024； 后在查看variable的值没有变化，这是为什么
- 安装mysql 出现无法安装 出现 a newer version of this product is already installed!!! 怎么解决
- 一个PDF文件，我用Adobe Reader或PDF阅读器打开，显示不了文件的实际内容，
- 无法给Mysql用户创建跟修改密码
- MY**L #1064错误
- navicat远程连接mysql数据库报错2013-
- win7 32位系统使用mysql 无法登录数据库 提示mysql: unknown variable ’character-set-server=utf8’
mysql 我用set global variable=32*1024*1024； 后在查看variable的值没有变化，这是为什么
用这个试一试
# For advice on how to change settings please see
# *** DO NOT EDIT THIS FILE. It’s a template which will be copied to the
# *** default location during install, and will be replaced if you
# *** upgrade to a newer version of My**L.
default-character-set=gbk
#default-character-set=utf8
default-character-set=gbk
#default-character-set=utf8
#default-character-set=gbk
#default-character-set=utf8
init_connect=’SET NAMES gbk’
#init_connect=’SET NAMES utf8’
character_set_server=gbk
#character_set_server=utf8
lower_case_table_names=0
#character_set_client=utf8
character_set_client=gbk
#init_connect=’SET collation_connection=gbk_chinese_ci’
#init_connect=’SET NAMES gbk’
#character-set-server=gbk
#collation-server=gbk_chinese_ci
skip-character-set-client-handshake
#sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
#sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
#sql_mode=NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
default-character-set=gbk
#sql_mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
# Remove leading # and set to the amount of RAM for the most important data
# cache in My**L. Start at 70% of total RAM for dedicated server, else 10%.
# innodb_buffer_pool_size = 128M
# Remove leading # to turn on a very important data integrity option: logging
# changes to the binary log between backups.
# log_bin
# These are commonly set, remove the # and set as required.
# basedir = .....
# datadir = .....
# port = .....
# server_id = .....
# socket = .....
# Remove leading # to set opti*** mainly useful for reporting servers.
# The server defaults are faster for transacti*** and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M
#sql_mode=NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
#sql_mode=NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
#sql_mode=STRICT_TRANS_TABLES
安装mysql 出现无法安装 出现 a newer version of this product is already installed!!! 怎么解决
你已经安装了一个mysql,并且比你现在安装的版本更新。要么就先删除掉以前的，要么就不要装了，直接用以前的就行了。
一个PDF文件，我用Adobe Reader或PDF阅读器打开，显示不了文件的实际内容，
你的Adobe reader 版本太低了，要你下个最新版本。
***隐藏网址***
无法给Mysql用户创建跟修改密码
error while fetching user information.The user might have been deleted
---------------------------------------------------------------------------------------------
提示是说mysql的user表数据被清了
你在cmd下 执行 mysql -u root -p 回车 不要输密码再回车，看看什么提示
满意请采纳。
MY**L #1064错误
出现这种情况是因为你建表的**L语句有错误，
你的给出的代码里option为MY**L关键字，不能直接写，需要用`包括起来，为： `option` varchar(50) NOT NULL default ’’
----下面就没问题了
CREATE TABLE components (
id int(11) NOT NULL auto_increment,
name varchar(50) NOT NULL default ’’,
link varchar(255) NOT NULL default ’’,
menuid int(11) unsigned NOT NULL default ’0’,
parent int(11) unsigned NOT NULL default ’0’,
admin_menu_link varchar(255) NOT NULL default ’’,
admin_menu_alt varchar(255) NOT NULL default ’’,
`option` varchar(50) NOT NULL default ’’,
ordering int(11) NOT NULL default ’0’,
admin_menu_img varchar(255) NOT NULL default ’’,
iscore tinyint(4) NOT NULL default ’0’,
params text NOT NULL,
PRIMARY KEY (id)
) TYPE=MyISAM;
扩展资料：
MY**L 报错解决：
1．Starting My**L.Manager of pid-file quit without updating fi
关于这个错误原因有很多，最大的可能是没有创建测试数据库，可以用/usr/local/mysql/scripts/mysql_install_db –user=mysql命令进行创建；另外一个原因可能是权限设置问题，需要赋予mysql的data权限，可以用chmod -R 命令。
2．FATAL ERROR: Could not find /home/mysql/bin/my_print_defaults If you are using a binary release,you must run this script from
within the directory the archive extracted into. If you compiled
My**L yourself you must run ‘make install’ first.
这个错误，是没有指明mysql的data路径导致的：
vim /etc/my.cnf
在 后面加上路径：
basedir = /usr/local/mysql
datadir =/opt/data；
3．-bash: mysql: command not found
用mysql命令进行**mysql报错，原因是没有设置环境变量，需要设置。
mysql -u root
4．ERROR 1130: Host ’192.168.1.3′ is not allowed to connect to this My**L server
用mysql远程工具链接数据库报错，这个错误原因是没有开放远程链接功能，可以在mysql里面输入如下命令进行解决：GRANT ALL PRIVILEGES ON *.* TO ’root‘@’%’ IDENTIFIED BY ’password’ WITH GRANT OPTION
navicat远程连接mysql数据库报错2013-
这个问题我以前帮客户做网站也经常碰到；
一般是空间提供商为了自身服务器安全而设定的；
禁止远程管理和其它空间的程序调用，引起整个数据库服务器崩掉；
你可以直接跟空间提供商联系，要求他开通你的远程管理权限；
因为我上次就是这样直接跟服务商交涉，几下就就OK的，据说就一条命令而以；
具体的方法有二种，请参考下面：
1。改表法。请使用mysql管理工具，如：**Lyog Enterprise可能是你的帐号不允许从远程**，只能在localhost。这个时候只要在localhost的那台电脑使用mysql管理工具登入mysql后，更改 "mysql" 数据库里的 "user" 表里的 "host" 项，从"localhost"改称"%"
2. 授权法。A:你想mysql账户myuser使用密码mypassword从任何主机连接到mysql服务器的话，那就在my**L命令行下输入：GRANT ALL PRIVILEGES ON *.* TO’myuser’@’%’IDENTIFIED BY ’mypassword’ WITH GRANT OPTION;若上面那条命令还没有奏效，那就使用下面的命令，一定成功!如果你想允许想mysql账户myuser从ip为192.168.1.3的主机连接到mysql服务器，并使用mypassword作为密码，那就在my**L命令行下输入：GRANT ALL PRIVILEGES ON *.* TO’myuser’@’192.168.1.3’IDENTIFIED BY ’mypassword’ WITH GRANT OPTION;
win7 32位系统使用mysql 无法登录数据库 提示mysql: unknown variable ’character-set-server=utf8’
用这个试一试
# For advice on how to change settings please see
***隐藏网址***
# *** DO NOT EDIT THIS FILE. It’s a template which will be copied to the
# *** default location during install, and will be replaced if you
# *** upgrade to a newer version of My**L.
default-character-set=gbk
#default-character-set=utf8
default-character-set=gbk
#default-character-set=utf8
#default-character-set=gbk
#default-character-set=utf8
init_connect=’SET NAMES gbk’
#init_connect=’SET NAMES utf8’
character_set_server=gbk
#character_set_server=utf8
lower_case_table_names=0
#character_set_client=utf8
character_set_client=gbk
#init_connect=’SET collation_connection=gbk_chinese_ci’
#init_connect=’SET NAMES gbk’
#character-set-server=gbk
#collation-server=gbk_chinese_ci
skip-character-set-client-handshake
#sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
#sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
#sql_mode=NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
default-character-set=gbk
#sql_mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
# Remove leading # and set to the amount of RAM for the most important data
# cache in My**L. Start at 70% of total RAM for dedicated server, else 10%.
# innodb_buffer_pool_size = 128M
# Remove leading # to turn on a very important data integrity option: logging
# changes to the binary log between backups.
# log_bin
# These are commonly set, remove the # and set as required.
# basedir = .....
# datadir = .....
# port = .....
# server_id = .....
# socket = .....
# Remove leading # to set opti*** mainly useful for reporting servers.
# The server defaults are faster for transacti*** and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M
#sql_mode=NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
#sql_mode=NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
#sql_mode=STRICT_TRANS_TABLES
