try to add a new user using mysql administrator 1.0.12
the following is my my.ini. I use an arabic database character set cp1256 with its proper collation when i tried to use mysql administrator with the my.ini with the mysql5.01 the mysql-administrator 1.0.12 reply an error of mixing two character sets
latin1_swedish_ci with the cp1256_general_ci
please could anybody help me
#This File was made using the WinMySQLAdmin 1.4 Tool
#31/03/2004 08:36:38 ص
#Uncomment or Add only the keys that you know how works.
#Read the MySQL Manual for instructions
[mysqld]
basedir=D:/mysql
#bind-address=192.37.2.25
datadir=D:/mysql/data
#language=d:/mysql/share/your language directory
#slow query log#=
#tmpdir#=
port=3306
default-character-set=cp1256
default-collation=cp1256_general_ci
default-table-type=InnoDB
default-storage-engine=InnoDB
key_buffer_size=20M
max_allowed_packet=10M
table_cache=64
sort_buffer=1024k
net_buffer_length=2048k
server-id=1
#This option makes InnoDB to store each created table into its own .ibd file.
innodb_file_per_table
#Don't resolve hostnames. All hostnames are IP's or 'localhost'.
skip-name-resolve
#Don't cache host names.
skip-host-cache
#Allow big result sets by saving all temporary sets on file (Solves most 'table full' errors).
big-tables
[WinMySQLadmin]
Server=D:/mysql/bin/mysqld-max-nt.exe
user=root
password=root
table_type=InnoDB
Subject
Written By
Posted
try to add a new user using mysql administrator 1.0.12
September 02, 2004 11:52AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.