相关文章推荐
谦和的西红柿  ·  联想小新摄像头怎么开启-百度经验·  3 月前    · 
闷骚的四季豆  ·  Closed windows still ...·  4 月前    · 
挂过科的大蒜  ·  Array.IndexOf 方法 ...·  5 月前    · 
怕老婆的手套  ·  C++错误:“const char *“ ...·  1 年前    · 
大气的大蒜  ·  央视主持人宋英杰发微博证实儿子记得前世_愚公 ...·  1 年前    · 
Code  ›  MySQL :: MySQL 8.0 Reference Manual :: 2.3.5 Troubleshooting a Microsoft Windows MySQL Server Installation
mysql linux系统 service
https://dev.mysql.com/doc/refman/8.0/en/windows-troubleshooting.html
冷冷的红薯
2 年前
Setting Alternative Server Paths with MySQL Installer
Installation Workflows with MySQL Installer
MySQL Installer Product Catalog and Dashboard
MySQL Installer Console Reference
Troubleshooting a Microsoft Windows MySQL Server Installation
Windows Postinstallation Procedures
Windows Platform Restrictions
General Notes on Installing MySQL on macOS
Installing MySQL on macOS Using Native Packages
Installing and Using the MySQL Launch Daemon
Installing and Using the MySQL Preference Pane
Installing MySQL on Linux Using the MySQL Yum Repository
Installing MySQL on Linux Using the MySQL APT Repository
Installing MySQL on Linux Using the MySQL SLES Repository
Installing MySQL on Linux Using RPM Packages from Oracle
Installing MySQL on Linux Using Debian Packages from Oracle
Deploying MySQL on Linux with Docker
Basic Steps for MySQL Server Deployment with Docker
More Topics on Deploying MySQL Server with Docker
Deploying MySQL on Windows and Other Non-Linux Platforms with Docker
Installing MySQL on Linux from the Native Software Repositories
Installing MySQL on Linux with Juju
Managing MySQL Server with systemd
MySQL Layout for Source Installation
Installing MySQL Using a Standard Source Distribution
Installing MySQL Using a Development Source Tree
Configuring SSL Library Support
MySQL Source-Configuration Options
Dealing with Problems Compiling MySQL
MySQL Configuration and Third-Party Tools
Generating MySQL Doxygen Documentation Content
Preparing Your Installation for Upgrade
Upgrading MySQL Binary or Package-based Installations on Unix/Linux
Upgrading MySQL with the MySQL Yum Repository
Upgrading MySQL with the MySQL APT Repository
Upgrading MySQL with the MySQL SLES Repository
Upgrading MySQL on Windows
Upgrading a Docker Installation of MySQL
Upgrade Troubleshooting
Rebuilding or Repairing Tables or Indexes
Copying MySQL Databases to Another Machine
When installing and running MySQL for the first time, you may encounter certain errors that prevent the MySQL server from starting. This section helps you diagnose and correct some of these errors. Your first resource when troubleshooting server issues is the error log . The MySQL server uses the error log to record information relevant to the error that prevents the server from starting. The error log is located in the data directory specified in your my.ini file. The default data directory location is C:\Program Files\MySQL\MySQL Server 8.0\data , or C:\ProgramData\Mysql on Windows 7 and Windows Server 2008. The C:\ProgramData directory is hidden by default. You need to change your folder options to see the directory and contents. For more information on the error log and understanding the content, see Section 5.4.2, “The Error Log” . For information regarding possible errors, also consult the console messages displayed when the MySQL service is starting. Use the SC START mysqld_service_name or NET START mysqld_service_name command from the command line after installing mysqld as a service to see any error messages regarding the starting of the MySQL server as a service. See Section 2.3.4.8, “Starting MySQL as a Windows Service” . The following examples show other common error messages you might encounter when installing MySQL and starting the server for the first time: If the MySQL server cannot find the mysql privileges database or other critical files, it displays these messages:

System error 1067 has occurred.
Fatal error: Can't open and lock privilege tables:
Table 'mysql.user' doesn't exist

These messages often occur when the MySQL base or data directories are installed in different locations than the default locations ( C:\Program Files\MySQL\MySQL Server 8.0 and C:\Program Files\MySQL\MySQL Server 8.0\data , respectively). This situation can occur when MySQL is upgraded and installed to a new location, but the configuration file is not updated to reflect the new location. In addition, old and new configuration files might conflict. Be sure to delete or rename any old configuration files when upgrading MySQL. If you have installed MySQL to a directory other than C:\Program Files\MySQL\MySQL Server 8.0 , ensure that the MySQL server is aware of this through the use of a configuration ( my.ini ) file. Put the my.ini file in your Windows directory, typically C:\WINDOWS . To determine its exact location from the value of the WINDIR environment variable, issue the following command from the command prompt:

C:\> echo %WINDIR%

You can create or modify an option file with any text editor, such as Notepad. For example, if MySQL is installed in E:\mysql and the data directory is D:\MySQLdata , you can create the option file and set up a [mysqld] section to specify values for the basedir and datadir options:

[mysqld]
# set basedir to your installation path
basedir=E:/mysql
# set datadir to the location of your data directory
datadir=D:/MySQLdata

Microsoft Windows path names are specified in option files using (forward) slashes rather than backslashes. If you do use backslashes, double them:

[mysqld]
# set basedir to your installation path
basedir=C:\\Program Files\\MySQL\\MySQL Server 8.0
# set datadir to the location of your data directory
datadir=D:\\MySQLdata

The rules for use of backslash in option file values are given in Section 4.2.2.2, “Using Option Files” . If you change the datadir value in your MySQL configuration file, you must move the contents of the existing MySQL data directory before restarting the MySQL server. See Section 2.3.4.2, “Creating an Option File” . If you reinstall or upgrade MySQL without first stopping and removing the existing MySQL service and install MySQL using the MySQL Installer, you might see this error:

Error: Cannot create Windows service for MySql. Error: 0

This occurs when the Configuration Wizard tries to install the service and finds an existing service with the same name. One solution to this problem is to choose a service name other than mysql when using the configuration wizard. This enables the new service to be installed correctly, but leaves the outdated service in place. Although this is harmless, it is best to remove old services that are no longer in use. To permanently remove the old mysql service, execute the following command as a user with administrative privileges, on the command line:

C:\> SC DELETE mysql
[SC] DeleteService SUCCESS

If the SC utility is not available for your version of Windows, download the delsrv utility from http://www.microsoft.com/windows2000/techinfo/reskit/tools/existing/delsrv-o.asp and use the delsrv mysql syntax.

 
推荐文章
谦和的西红柿  ·  联想小新摄像头怎么开启-百度经验
3 月前
闷骚的四季豆  ·  Closed windows still occupy space after updating to Sequoia · Issue #2426 · koekeishiya/yabai · GitH
4 月前
挂过科的大蒜  ·  Array.IndexOf 方法 (System) | Microsoft Learn
5 月前
怕老婆的手套  ·  C++错误:“const char *“ 类型的值不能用于初始化 “char *“ 类型的实体_c++ 类型的值不能用于初始化 类型的实体-CSDN博客
1 年前
大气的大蒜  ·  央视主持人宋英杰发微博证实儿子记得前世_愚公_新浪博客
1 年前
今天看啥   ·   Py中国   ·   codingpro   ·   小百科   ·   link之家   ·   卧龙AI搜索
删除内容请联系邮箱 2879853325@qq.com
Code - 代码工具平台
© 2024 ~ 沪ICP备11025650号