Differences

This shows you the differences between two versions of the page.

--- wamp:mysql:set_pass [2016/02/12 06:51] – rplecko
+++ wamp:mysql:set_pass [2016/02/12 07:00] (current) – external edit 127.0.0.1
@@ Line 1: / Line 1: @@
+===Set password to MySQL server===
+//"BUILD YOUR OWN DATABASE DRIVEN WEB SITE USING PHP & MYSQL" BY KEVIN YANK 4th edition//
 <code>
 mysqladmin -u root status
@@ Line 33: / Line 37: @@
 Replace newpassword with whatever password you’d like to use for your MySQL
 server. Make sure it’s one you can remember, because if you forget your MySQL
-root password, you might need to erase your entire MySQL installation and start over from scratch! As we’ll see in Chapter 10, it’s usually possible to recover from such a mishap, but it’s definitely a pain in the neck.
+root password, you might need to erase your entire MySQL installation and start over from scratch! It’s usually possible to recover from such a mishap, but it’s definitely a pain in the neck.
+Let me break this command down for you, so you can understand what each part
+means:
+<code>
+mysqladmin
+</code>
+This, of course, is the name of the program you wish to run.
+<code>
+-u root
+</code>
+This specifies the MySQL user account you wish to use to connect to your
+MySQL server. On a brand new server, there is only one user account: root.
+<code>
+-p
+</code>
+This tells the program to prompt you for the current password of the user account. On a brand new MySQL server, the root account has no password, so
+you can just hit Enter when prompted. It’s a good idea, however, to make a habit
+of including this option, since most of the time you will need to provide a
+password to connect to your MySQL server.
+<code>
+password "newpassword"
+</code>
+This instructs the mysqladmin program to change the password of the user account to newpassword. In this example, whatever password you specify will
+become the new password for the root MySQL user.
+Now, to try out your new password, request once again that the MySQL server tell
+you its current status at the system command prompt, but this time include the -p option:
+<code>
+mysqladmin -u root -p status
+</code>
+Enter your new password when prompted. As before, you should see a line or two
+of statistics about your MySQL server.
+Since the root account is now password-protected, attempting to run this command
+without the -p switch will give you an “Access Denied” error.