after installing the mysql service, you can use mysql-u root-p
, restart the computer and then try to log in
ERROR 1045 (28000): Access denied for user "root"@"localhost" (using password: YES)
how to solve it?
after installing the mysql service, you can use mysql-u root-p
, restart the computer and then try to log in
ERROR 1045 (28000): Access denied for user "root"@"localhost" (using password: YES)
how to solve it?
this error is usually caused by the wrong user name and password of the database you want to connect to. Check it carefully.
Previous: The require.context method in Webpack cannot be found in Jest
Next: How does the linux in the vmware virtual machine map to the directory of the windows host?
add data to the database in positive order, can you add it in reverse order (not select * from table name by ID desc) is the data in the data table displayed in reverse order ...
has always thought that index optimization is effective in where is useless in select but it seems that there is a performance difference between select nonclustered index columns, clustered index columns, unindexed columns and select *? ...
I would like to ask the gods, the speed of unwritten-out writing is fast, or the speed of logged-out is fast, why? now it is a joint check of two tables, and the amount of data is small. If there is a large amount of data, which method is more advantag...
such as the title. see that MySQL generates a tree for the primary key, and the leaf node holds the row data corresponding to the primary key. The secondary index leaf node holds the value of the primary key. excuse me: does the leaf node of th...
EXPLAIN SELECT s.id, s.name, s.price, s.unit, s.qty, s.remark, s.image, s.cuft, s.volume, s.status, s.vender_id AS venderId, s.booth_id AS boothId, s.booth_no AS boothNo, s.show_booth_no AS showBoothNo, s.name_en AS nameEn, ...
now I have an array, which contains about 100000 of the data, all personId,. I now need to use this ID to query other data in another table. Is there any good way to make the query more efficient? Whether IN can be used or not, although it is easy to wri...
The index is a data structure in which the leaf node of the b + tree holds pointers to the actual rows. what about clustered indexes? what does InnoDB s clustered index mean by storing B+Tree indexes and data rows in the same structure? Does mean that...
for example, I like % R% answer, the query results include not only R, but also r, which is not what I want, I want to be case-sensitive. I guess it has something to do with the proofreading rules of the table. My table uses utf8mb4 encoding, and the pr...
take MySQL as an example, what is the difference (principle and efficiency) between in and exists and between not in and not exists? What about using indexes? Say that not in and < > will not use indexes, won t you? ...
has such a logic, a piece of data, if there is in the database, then update, if it does not exist, then insert. But now there are ten thousand. So how to accomplish the task efficiently? ...
I have been using python3 + flask, before. I recently watched a project video of Django. There are all kinds of problems in configuring the environment when python2.7 uses django on win10. There are problems in installing mysql-python and ansible packag...
if the table table has a federated index (sex, id) and id itself is the primary key , does the following sql go to the index? select * from table where sex= m order by id limit 1000000,10 my feeling is that according to the execution order of sql ...
background and phenomena the amount of data in the report_product_sales_ data table is 28 million; it has been tested that when the, order by primary key id,limit reaches 49 under the current data volume, the PRIMARY primary key index can be used w...
as mentioned above, after starting the master-slave Synchronize, the master may not have all the binlog, so how is the original data transmitted to the slave? for example, if there are 5000 data items on master, and then binlog and master-slave Synchron...
I have a table exchange CREATE TABLE `exchange` ( `id` int(11) NOT NULL AUTO_INCREMENT, `rank` int(11) NOT NULL, `name` varchar(255) NOT NULL, `volume` varchar(255) NOT NULL, `timestamp` datetime NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB...
when there are too many SQL pages (for example, limit 1000000,20), the efficiency will be significantly reduced. How to optimize it? Here, take mysql as an example ...
< H1 > question < H1 > the data table needs a column to keep the current time, and then it needs to be accurate to milliseconds , and then search it. It is found that datetime can take decimals. According to this blog TIMESTAMP(3) DATETIME(3)3 T...
one step of the installation-free version is mysqld -install someone will use mysqld install some people will use . mysqld --install I don t know what the difference is and why they all succeed. ...
there is a usr table containing uid,username business table 1, the information stored are fields uid,username business table 2, and only uid, (multiple data in business table 2 corresponds to one data in business table 1) the environmental backgrou...
I have a table service_message that contains about 600000 pieces of data, which records when different devices receive messages: SHOW CREATE TABLE service_message CREATE TABLE `service_message` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `device_id` I...