Shulou(Shulou.com)06/01 Report--

MySQL installation-free configuration

1. Open the file my-huge.ini and save it as my.ini, and add the following configuration to the my.ini file Then put the [mysqld] basedir=E:/share/mysql # bind-address=127.0.0.1 datadir=E:/share/mysql/data # language=D:/usr/local/mysql/share/your language directory # slow query log#= # tmpdir#= # port=3306 # set-variable=key_buffer=16M [WinMySQLadmin] Server=E:/share/mysql/bin/mysqld-nt.exe user=root password=mysql * path under C:/windows to modify according to the individual's situation. 2. Start-enter: E:/share/mysql/bin/mysqld-nt.exe-install to start the MySQL service and start it automatically. If you don't restart the computer, see if you have it. 3. Set MySQL Chinese character set (MySQL displays Chinese normally) 1). Configure the server side, modify the my.ini file, use the Chinese character set to store records, and use Chinese sorting and comparison. [mysqld] # set character set default-character-set=gbk # set character collation default-collation=gbk_chinese_ci 2). If you want to use the mysql command line on the server side of the Chinese environment, change the default character set of mysql in the my.ini file. [mysql] # set character set default-character-set=gbk 3). In the client program, set the Chinese character set. Take Delphi + ADO + MyODBC as an example: procedure InitConn; var nRows: Integer; begin. / / change the character set ADOConnection1.Execute ('set character_set_client=''gbk''', nRows); ADOConnection1.Execute (' set character_set_connection=''gbk''', nRows); ADOConnection1.Execute ('set character_set_results=''gbk''', nRows) of the current MySQL connection session.

[@ more@]

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.