mysql -h localhost -u root mysql> USE mysql; mysql> UPDATE user SET Password=PASSWORD('root-pwd') WHERE user='root'; mysql> FLUSH PRIVILEGES; mysql> EXIT
Never been to CodeSnippets before?
Snippets is a public source code repository. Easily build up your personal collection of code snippets, categorize them with tags / keywords, and share them with the world (or not, you can keep them private!)
Change Root user password (See related posts)
You need to create an account or log in to post comments to this site.
Related Posts
» Creating a MySQL database an... in mysql databases users
» SSH tunneling for MySQL in mysql ssh tunneling remote
» password hash script in ruby password
» MySQL launchd item for Mac O... in mysql osx 10.4 tiger launchd
» Creating a quick dump for yo... in mysql
» Looking for the MySQL socket in mysql
Snippets (source code soon to be available) developed by Peter Cooper and powered by Ruby On Rails