MySQL5.5.38 Installation Problems

Remove 5.1.73 and install 5.5.38. The system starts and disables netstartmysql; netstopmysql; and deletes services: two methods are available: scdeletemysqlmysqld-remove install mysqld -- installmysql -- defaults-fileD: mysql5.38my. ini -- install the service name followed. 5.5

Remove 5.1.73 and install 5.5.38. The system starts and disables net start mysql; net stop mysql; and deletes services. Two methods are available: SC delete mysql mysqld-remove install mysqld -- install mysql -- defaults-file = D: \ mysql 5.5.38 \ my. ini -- install is followed by the service name. 5.5

Remove 5.1.73 and install 5.5.38.

System startup/Shutdown

Net start mysql;

Net stop mysql;

Delete A service: Two Methods

SC delete mysql

Mysqld-remove

Install

Mysqld -- install mysql -- defaults-file = "D: \ mysql 5.5.38 \ my. ini"

-- Install the name of the event service.

5.5.38 and 5.1.73 are different:

Mysqld

5.1.73 default-character-set = utf8

5.5.38 character-set-server = utf8

There are also differences in log names. Remember not to be clear.

Slow_query_log

Log_slow_query

In addition, errors in dir settings may also cause 1067 system errors.

# Basic system directory

Basedir = C:/srv/mysql-5.5.19
# User data directory

Datadir = E:/myWeb/mysql5data/data

E it.

Paste the error log:

140707 11:37:55 InnoDB: Starting shutdown...
140707 11:37:55 InnoDB: Shutdown completed; log sequence number 1595675
140707 11:37:55 [Note] D: \ MySQL 5.5.38 \ bin \ mysqld: Shutdown complete


140707 11:40:27 [Note] Plugin 'federated 'is disabled.
140707 11:40:27 InnoDB: The InnoDB memory heap is disabled
140707 11:40:27 InnoDB: Mutexes and rw_locks use Windows interlocked functions
140707 11:40:27 InnoDB: Compressed tables use zlib 1.2.3
140707 11:40:27 InnoDB: Initializing buffer pool, size = 2.0G
140707 11:40:27 InnoDB: Completed initialization of buffer pool
140707 11:40:27 InnoDB: highest supported file format is Barracuda.
140707 11:40:28 InnoDB: Waiting for the background threads to start
140707 11:40:29 InnoDB: 5.5.38 started; log sequence number 1595675
140707 11:40:29 [ERROR] D: \ MySQL 5.5.38 \ bin \ mysqld: unknown option '-- skip-locking'
140707 11:40:29 [ERROR] Aborting


140707 11:40:29 InnoDB: Starting shutdown...
140707 11:40:30 InnoDB: Shutdown completed; log sequence number 1595675
140707 11:40:30 [Note] D: \ MySQL 5.5.38 \ bin \ mysqld: Shutdown complete


140707 11:43:45 [Note] Plugin 'federated 'is disabled.
140707 11:43:45 InnoDB: The InnoDB memory heap is disabled
140707 11:43:45 InnoDB: Mutexes and rw_locks use Windows interlocked functions
140707 11:43:45 InnoDB: Compressed tables use zlib 1.2.3
140707 11:43:45 InnoDB: Initializing buffer pool, size = 2.0G
140707 11:43:45 InnoDB: Completed initialization of buffer pool
140707 11:43:45 InnoDB: highest supported file format is Barracuda.
140707 11:43:46 InnoDB: Waiting for the background threads to start
140707 11:43:47 InnoDB: 5.5.38 started; log sequence number 1595675
140707 11:43:47 [ERROR] D: \ MySQL 5.5.38 \ bin \ mysqld: unknown variable 'default-character-set = utf8'
140707 11:43:47 [ERROR] Aborting


140707 11:43:47 InnoDB: Starting shutdown...
140707 11:43:47 InnoDB: Shutdown completed; log sequence number 1595675
140707 11:43:47 [Note] D: \ MySQL 5.5.38 \ bin \ mysqld: Shutdown complete


140707 11:45:51 [Note] Plugin 'federated 'is disabled.
140707 11:45:51 InnoDB: The InnoDB memory heap is disabled
140707 11:45:51 InnoDB: Mutexes and rw_locks use Windows interlocked functions
140707 11:45:51 InnoDB: Compressed tables use zlib 1.2.3
140707 11:45:51 InnoDB: Initializing buffer pool, size = 2.0G
140707 11:45:52 InnoDB: Completed initialization of buffer pool
140707 11:45:52 InnoDB: highest supported file format is Barracuda.
140707 11:45:52 InnoDB: Waiting for the background threads to start
140707 11:45:53 InnoDB: 5.5.38 started; log sequence number 1595675
140707 11:45:53 [ERROR] D: \ MySQL 5.5.38 \ bin \ mysqld: unknown variable 'default-character-set = utf8'
140707 11:45:53 [ERROR] Aborting


140707 11:45:53 InnoDB: Starting shutdown...
140707 11:45:54 InnoDB: Shutdown completed; log sequence number 1595675
140707 11:45:54 [Note] D: \ MySQL 5.5.38 \ bin \ mysqld: Shutdown complete