Mysql notes - Revision history

Leo: /* Backup a database */

2011-06-03T12:22:09Z

‎Backup a database

2011-06-03T11:50:10Z

‎Lost MySQL password?

2011-02-11T17:09:21Z

‎Backup a database

2010-12-30T23:05:53Z

2009-02-18T09:58:51Z

‎Links

2009-02-18T09:58:40Z

‎Links

2009-02-18T09:58:26Z

‎Links

2009-02-18T09:36:03Z

2009-02-18T09:32:53Z

New page: == Links == * [http://www.nparikh.org/unix/mysql.php Mysql Cheat-sheet]

New page

== Links ==

* [http://www.nparikh.org/unix/mysql.php Mysql Cheat-sheet]

@@ Line 10: / Line 10: @@
  mysqldump -u root -p [databasename] > [backupfile.sql]
+== Restore a database ==
+ mysql -u root -p [databasename] < [backupfile.sql]
 == Change a root password ==

@@ Line 24: / Line 24: @@
   sudo /etc/init.d/mysql stop
   sudo mysqld --skip-grant-tables
   mysql -u root
   mysql> UPDATE mysql.user SET Password=PASSWORD('password') WHERE User='root';
   mysql> FLUSH PRIVILEGES;
   mysql> exit
-  sudo mysqladmin shutdown -u root
+  sudo mysqladmin shutdown -u root -p
   sudo /etc/init.d/mysql start

@@ Line 10: / Line 10: @@
  mysqldump -u root -p [databasename] > [backupfile.sql]
+== Change a root password ==
+Change an existing Mysql root password like this:
+ mysqladmin -u root -p'oldpassword' password 'newpassword'
 == Lost MySQL password? ==

@@ Line 3: / Line 3: @@
 * [http://www.nparikh.org/unix/mysql.php Mysql Cheat-sheet]
 * [http://diveintomark.org/archives/2007/11/11/installing-mysql-on-ubuntu no-nonsense mysql installation guide...] :-)
+== Backup a database ==
+You may want to log in mysql and do "show databases;" to see which to backup, then do it like this.
+ mysqldump -u root -p [databasename] > [backupfile.sql]
 == Lost MySQL password? ==

@@ Line 2: / Line 2: @@
 * [http://www.nparikh.org/unix/mysql.php Mysql Cheat-sheet]
-* [http://diveintomark.org/archives/2007/11/11/installing-mysql-on-ubuntu no-nonsense mysql installation guide...] :)
+* [http://diveintomark.org/archives/2007/11/11/installing-mysql-on-ubuntu no-nonsense mysql installation guide...] :-)
 == Lost MySQL password? ==

@@ Line 1: / Line 1: @@
 == Links ==
 * [http://www.nparikh.org/unix/mysql.php Mysql Cheat-sheet]
+== Lost MySQL password? ==
+By example: recreated mysql passwords for the wikiuser and mysql-root.
+You can reset root password - stop mysql and start the daemon like this:
+* reset mysql root password
+  sudo /etc/init.d/mysql stop
+  sudo mysqld --skip-grant-tables
+  mysql -u root
+  mysql> UPDATE mysql.user SET Password=PASSWORD('password') WHERE User='root';
+  mysql> FLUSH PRIVILEGES;
+  mysql> exit
+  sudo mysqladmin shutdown -u root
+  sudo /etc/init.d/mysql start
+* Change mysql wikiuser password
+  $ mysql -u root -p
+  mysql> use mysql;
+  mysql> update user set password=PASSWORD("NEWPASSWORD") where User='wikiuser';
+  mysql> flush privileges;
+  mysql> quit