directory for MySQL database
datadir=d:/db/mysqldata
# allow maximum number
of connections max_connections=200
# The character set used by the service side defaults to a 8-bit encoded latin1 character set
Character-set-server=utf8
# The default storage engine that will be used when creating a new table
Default-storage-engine=innodb
Other configuration items are set according to their own needs and are not explained here.Iv. Configure the service and start 1. Run cmd as Administrator and go to
Label:Original: MySQL green version of installation (Mysql-5.6.22-win32.zip)Because the work needs to start studying MySQL recently (it seems that learning is forced out), I do not study MySQL, can say a small white. Let's start with the installation, although there are many things on the internet that need to be written down.1. Database downloadMySQL official website: http://www.mysql.com/, database: http:
Mysqlgreen version (install the image and text tutorial of the zipdecompressed version (mysql-5.6.22-win32.zip), and download the mysql5.6 green version
1. database download
Official Mysql Website: http://www.mysql.com/, data warehouse: http://www.mysql.com/downloads /. You can find two types of file packages on the official website: exe and zip. I like the refre
process of growth must.4. Login and maintain MySQLInstallation is successful, also started, how to login ah? What is a user name and password?The default user name for MySQL is root and the password is empty.How do I log in? Or start-run--CMD,CD to the bin directory, and then execute "mysql-u root-p", prompting for a password, because the first run, the password is empty can be directly entered.Let's set a password for the database. Enter exit to exit the login. Then run Run C:\Program files\my
Tags: DMI arch hive nis com root down start addMySQL Community Server 5.5.56 ZIP Archive Green Decompression window installation steps First of all Get ready to start the configuration file My.ini [Mysqld]
#设置字符集为utf8
loose-default-character-set = UTF8
basedir = f:/ide/mysql5.5
DataDir = F:/ide/mysql5.5/data
[client]
#设置客户端字符集
loose-default-character-set = UTF8
[winmysqladmin]
Server = f:/ide/ Mysql5.
. Let's set a password for the database. Enter exit to exit the login. Then run Run C:\Program files\mysql-5.6.22-win32\bin\mysqladmin-uroot-p password Run "show variables like '%version% '" To view database related information This completes the installation of the entire database. Although the MySQL client can do all about the database operation, but the Black command line interface is still a lot of people to be deterred, learning curve straight up, here to recommend a tool navicate for
Tags: style blog tar ext c color20140220-mysql the installation (using Zip Unzip the green installation method)Google input MySQL can directly find the official website. Download the green version. Select: MySQL Community Server . If you have already installed the MySQL You can do this first:( 1 ) Stop MySQL of services: net stop MySQL (no semicolon required)( 2
Set environment variable path, point to the bin directory under MySQL
Modify the My-default.ini under MySQLBasedir=%mysql_home%Datadir=%mysql_home%\data
To the MySQL bin directory to executeMysqld--install(Delete Service is MySQL--remove)PS: note, be sure to go to the Mysql/bin directory to execute, or start service errorThe notation for adding parametersMysqld--install MySQL--defaults-file= "D:\Program Files (x86) \mysql\my.ini"
net start MySQL startup service
net stop MySQL shutdow
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.