– 1: download the mysql installation package. – 2: decompress the installation package to a disk. – 3: Check whether the bin file exists
window my.ini
linux etc/my.cnf
Copy the code– 4: bin Specifies whether the mysql.exe program exists
Mysqld --initialize --console execute my. Ini configuration file success: Temporary password is generated for root@localhost:, bin Is generated for running program files data Stores data files in the database Press, login user name, create data by yourself, etcCopy the code– 5: create service mysqld –install service name
Mysqld --install mysql --install WJH server name --> mysql --install WJH server name --> mysql --install WJH server nameCopy the code– 6 Starting mysql services **net start Mysql service name
Net start mysql default configuration NET start WJH custom configuration Let the Window system run mysql service, And to establish the link of window system and service -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- a bug -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- the reason: 1: service startup failed 2: The window system failed to connect to the service. Throw is the window system prompt error net command about common - 2182-3534 - no system permissions, etcCopy the code-7: log in to the myssql database **mysql -u root -p**
Note: 1: running mysql. Exe program 2: pay attention to the mysql command should in mysql. Exe under the same path -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- a bug -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- - 1: 2: mysql.exe program does not exist 3:..... Exe is the client program of the database. The server program of the database needs to find 1 in the following files: Window +r -->regedit database registry HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\Services\Eventlog\Application\MySQL\ HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Eventlog\Application\MySQL HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\Services\MySQLCopy the code-8: Uses SQL to operate the database
Database new link break link table: new view Delete field: new delete update Confirm primary key record: specific data such as Zhang SAN 21 ha ha ha 1 add delete update query ***Copy the code-9 For running mysql
1: change mysql to global command in the system environment variable configuration file 2: Install the visualization tool navCat of mysql.exeCopy the code