Skip to main content

How to Rest Mysql Server Root Password in Case it was Forgotten

First you need to stop mysql service:

/etc/init.d/mysqld stop
 
 Now Start mysql in safemode:

mysqld_safe --skip-grant-tables 
 
Login as root:
 
mysql --user=root mysql
 
Now run the below:
 
update user set Password=PASSWORD('new-password') where user='root';
flush privileges;
exit;
 
Finally kill mysql process and start it again:
 
/etc/init.d/mysqld stop
 
/etc/init.d/mysqld start
 
 
Labels:

Comments

Post a Comment

Popular posts from this blog

Top Google Adsense Alternatives

Google Adsense is a web tool that allows publishers in the Google Network of content sites to automatically serve text, image, video, and rich media adverts that are targeted to site content and audience. These adverts are administered, sorted, and maintained by Google, and they can generate revenue on either a per-click or per-impression basis.  Google servers advertisers using google adwords platform, while adsense is the publishers platform. Google Adsense is the top Ad Publishers platform over the web ranking number one in web advertising industry. Adsense offers contextual advertisements that covers web sites, blogs, games, videos, mobile browsing etc. What made Google Adsense no. 1 is the reliability, stability, variety of services and large number of publishers including google it self. Also google has a fair platform that detects invalid clicks so google successfully protects its advertisers and also offers its best publishers top CPC. Two reasons are behind people think
11 comments
Read more

CFLDAP Add Active Directory User to a Group

I was trying to add a user to a group and had lots of code formatting etc. I was unable to find a straightforward code to help me. I have prepared the below code to help you using CFLDAP and also I will give you an alternative way using the dsmod command line. Lets start first with the CFLDAP: Now lets add an active directory user to a group using command line: When I wrote the above code I added a bulk list of users to a certain Active Directory group. Sometimes the CFLDAP failed so in the cfcatch I called the dsmode using the cfexecute. Why? Some of the user CN names contained special characters like 'bracket (' this caused an error when using the cfldap to add users to the groups so I had to use the cfexcute which succeeded.
Post a Comment
Read more