DOS command login MySQL show "Unable to run on PC" post-processing notes

The training class teacher uses DOS to log MySQL I follow the result--| | What a ghost! WTF? I don't favor him. What has he experienced in the last two months? Oh, it's a temper.

Then Baidu, most (I found) are "system error 5" and then "Access Denied", that is the permissions problem, the specific can search for change permissions on OK (probably Jiangzi), but I am not ah??

So I figured out another way to get into MySQL through DOS (the Big God Light spray ...) (((M-__-) m):

Enter it in turn:d:--------->mysql-uroot-p-------------> enter your mysql password------------------->use a database------------ > in common sense, you can do whatever you want!

-------------------Gorgeous split-line------------------------------------------------------------------------------------------O (*￣▽￣*) ブ----------------------------------------------------

If a friend sees that this solves the problem then do not turn back, because behind is my series of silly * behavior, why do this behavior? Because in the above way, my table can be displayed, but the contents of the list are missing.

Show tables;//can see your watch

SELECT * FROM ^;//hint does not exist for this table

Why is the contents of the table missing? Because I re-loaded the database (Off-topic, unload the database must be uninstalled clean, otherwise it will be very troublesome orz I write the unloading, I think very clean), once the table folder is also smart I back up it down.

after the database has been installed, the data is replaced by my data. Hahaha is so smart that he thinks it's done.

Later, however, the contents of the table were gone, but the tables were still there.

So I went to

This configuration file to see the path of the DataDir is the position of the table is not where I replaced the position (the MySQL process before the change, this will be? "My Computer" right-click Management---service--mysql--right -click Stop)

The mouse in the line! is the path where your table is located, you can change it! When I saw it, I realized: "Hey? Uppercase data? That's not good, I copied the lowercase d, so change the letter, and then!!! He won't let it change!!

Try the database I originally stored the path, because there are tables, see if I can do (I day, put is so messy, do not like me to put things in a mess!! ）

Yes, just don't let it change! Can't change it? copy out rename paste back, give cover on!! How to change what you want to change!

Tragedy (; ′д ') ゞmysql process is not open! Oh, well, maybe you can't use the space of the previous table, and then change back to the picture on the map, you can open it! So can not start the problem may be datadir modification.

So why in the end my table content is missing, because I back up the Data folder does not ibdata1 this file (the most critical file, or your table will be in the form of a dummy).

Ib_logfile0 and Ib_logfile1 are some log files about the database;

The. frm file is a structural description file for many tables in the database;

The Ibdata1 file is the real data storage file for the database.

In the end, how did I finish it? Re-build the table. And then you have a happy heart:

Eat melon audience: good! In the end, you still haven't solved the problem?

Me: "I think the lesson of failure is more important than the method of success ," I borrowed from this year's seniors to give us a speech!!

Handsome turned ~

(If you know what's wrong with my series of feel free, please!) ）

DOS command login mysql display "Cannot run on PC" post-processing notes