How to install mysql without mysql library

The differences between the database and MySQL and MySQL servers are as follows:

The database includes MySQL, and the MySQL server is a server as long as it functions;

MySQL is short, easy to use, easy to use, and free to use. Compared with other databases, it has more distinctive and practical syntax. SQL is also a large database, stable, can be used as a data warehouse for general large systems, and the running speed is significantly faster than MySQL.

Disadvantages: MySQL is difficult to serve as a data warehouse for large systems, and the running speed is slow, not stable enough, and there are disconnections. sqlserver** is expensive, and it is more difficult to use than mysql, after all, things are bigger and more talking.

MySQL has its own text interface client, of course, there is a professional client software for pairing MySQL, and various operations are really convenient. sqlserver logs in with the built-in query analyzer, both provided that the database service is turned on and you know the username and password for installation.

Although SQL Server is narrow, the conservative storage engine is very different from the scalable, open storage engine of MySQL Server. While you can use the SQL server's Sybase engine, MySQL offers a wider variety of options such as Myisam, Heap, InnoDB, and doesn't fully support unfamiliar keywords, so it has fewer related databases than SQL Server. At the same time, MySQL is lacking.

It must have been uninstalled last time, so I uninstalled the ones you installed first, and then went to Documents and Settings to find files related to mysql and deleted them all, and I just installed them.

On what system is it installed on? What error message went wrong? Error messages are pasted out.

This is because I have installed mysql in the machine before, and I did not uninstall it cleanly when I uninstalled it, because some folders are hidden deeply.

1. Uninstall MySQL related components;

2. Delete the installation directory of mysql;

3. Query MySQL in the registry (regedit) and delete all of them;

cmd ->regedit

Directory. Directory.

Directory. 4. Search for MySQL in C drive and delete all folders. There is a mysql folder in C: ProgramData when searching here, but there is no such folder under the root directory of the C drive, I don't know why, anyway, I don't care about it, just type C:

ProgramDataFind the mysql folder and delete it.

5. Restart your computer and reinstall it. Note: If you don't restart the computer, you will see a red cross in the third step when you install it again.

2. If the installation version is too cumbersome, you can directly use the decompressed version of MySQL.

1. Pressurize the file and put it in any directory, mine is directly placed under the E disk, e: mysql server;

2. Modify the file, basedir=e: the directory where mysql server is located).

datadir=e: mysql server (directory where mysql is located: data).

3. Configure environment variables to directly add the path where the bin directory under MySQL is located to the path;

4. Run cmd as an administrator (you must run it as an administrator, otherwise the permissions are not enough), enter :cd e: mysql server to enter the bin folder of mysql.

Enter mysqld -install (if you don't run it as administrator, you will get the error "install remove of the service denied!" because you don't have enough permissions.))

5. Successful installation

6. Enter net start mysql in cmd to start the service.

alt="n block》The system can't find the file", check whether the configuration file has been modified or whether it has entered the bin directory operation, if the configuration file is modified correctly and enters the bin folder, you need to delete mysql first (enter mysqld -remove) and then reinstall (enter mysqld -install);

If error 1067 occurs, it is a configuration file modification error, make sure that the configuration file is correct.

7. After the service is successfully started, you can log in, as shown in the figure, enter mysql -u root -p (there is no password for the first login, press enter directly), and the login is successful!

Set your computer to display hidden folders.

Open C: ProgramData, find the MySQL folder, and delete it.

Re-run the MySQL installer to install MySQL successfully

This is because you have previously installed MySQL and you need to uninstall the previous MySQL or replace the port of the new MySQL you want to install. The previous MySQL occupies port 3306, and if you want to install the new MySQL using port 3306, the installation will fail.

If you have uninstalled MySQL before, you can press and hold the Ctrl + Alt + Delete keys on your keyboard, and then check the "Processes" to see if there is "Running, if so, right-click to end the process". Then you can install the new MySQL.

It should be that there was an abnormal load when uninstalling at that time, resulting in the service name not being deleted synchronously.

Run sc create mysql under cmd, if there is such a service name, then stop it first, net stop mysql

Then run sc delete mysql to delete the mysql service name, and then reinstall mysql and it should be fine.

I suggest you try it like this:

The first is the driver file for C to operate MySQL, which is a necessary plug-in for C to connect to MySQL and make the C language more concise for operating MySQL databases. When your computer pops up with an error such as "lost source base xun or" can not be found, please ** this site provides you with the dll file, use it to help users solve the above problems.

DLL File Repair Methods:

2. Copy the file to the system directory.

3. The system directory is generally: C: Winnt System32 and the 64-bit system is C: Windows Syswow64

4. Finally, click Start Menu --> Run --> enter regsvr32, press enter and hail to solve the error prompt!