Reset Mysql root user's password

1. Stop MySQL:

Win: Stop it in services.msc, or run ...

net stop mysql 

 2. Sometimes in Windows it is necessary to uncomment this line in /windir/system32/drivers/etc/hosts:

127.0.0.1 localhost 
3. Start the MySQL server specifying your defaults-file (if you don't know that filename, see "What config file is the MySQL server using?"), and bypassing authentication ...

mysqld --defaults-file="..." --skip-grant-tables

 4. In another commandline window, start the mysql client:

mysql 
5. Verify that the name of the admin user is 'root'; you cannot create users when running with skip-grant-tables):

select user,host,authentication_string from mysql.user; 

 6. Change root user's password
Substitute the desired root password for 'new_pwd':

--  Ver 14.14 Distrib 5.7.22, for Win64 (x86_64):
flush privileges; 
alter user 'root'@'localhost' identified by 'new_pwd';
flush privileges;
exit; 

 7. Stop mysqld in Task Manager or in another command window...

mysqladmin shutdown 

 8. Restart MySQL

Yorumlar

Yeni yorumlara izin verilmiyor.

Bu blogdaki popüler yayınlar

SDLC - Software Development Life Cycle

Resim
SDLC -  Software Development Life Cycle  is a process used by the software industry to design, develop and test high quality softwares. 1- Requirement Analysis 2- Defining Requirements To clearly define and document the product requirements SRS (Software Requirement Specification)   document which consists of all the product requirements to be designed and developed during the project life cycle. 3-   Designing the Product Architecture One design approach for the product architecture is proposed and documented in a DDS - Design Document Specification . DDS is reviewed by all the important stakeholders and based on various parameters as risk assessment, product robustness, design modularity, budget and time constraints, the best design approach is selected for the product. DDS defines all the architectural modules of the product along with its communication and data flow representation with the external and third party modules. 4- Developing the ...
Devamı

@SerializedName and @Expose annotations

The  @SerializedName  annotation is needed for Gson to map the JSON keys with our fields. In keeping with Java's camelCase naming convention for class member properties, it is not recommended to use underscores to separate words in a variable.  @SerializedName  helps translate between the two. @SerializedName ( "quota_remaining" ) @Expose private Integer quotaRemaining; In the example above, we are telling Gson that our JSON key  quota_remaining  should be mapped to the Java field  quotaRemaining .  If both of these values were the same, i.e. if our JSON key was  quotaRemaining  just like the Java field, then there would be no need for the  @SerializedName  annotation on the field because Gson would map them automatically. The  @Expose  annotation indicates that this member should be exposed for JSON serialization or deserialization. 
Devamı