Differences

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

--- mysql [2006/10/24 12:33]
a
+++ mysql [2012/10/11 20:57]
94.23.1.28 EHNvAaHEfVFkEd
@@ Line 1: / Line 1: @@
-====== MySQL (*nix setup) ======
+You know, the thing about SQL is, that there is virtually noithng that can replace it.Does anyone know if a substitute exists for sql? I mean besides MS SQL and Oracle and all that jazz. Thanks.
-   * [[mysql:troubles|problems?]]
-//TODO
-//
-  - shutdown MySQL
-  - start MySQL with `mysqld_safe --skip-grant-tables &`
-  - set password either with :
-      `mysqladmin -u root flush-privileges password "newpwd"`
-    or
-      `mysql -u root mysql`
-      Issue the following commands in the mysql client:
-      mysql> UPDATE mysql.user SET Password=PASSWORD('newpwd') WHERE User='root';
-      mysql> FLUSH PRIVILEGES;
-GRANT ALL PRIVILEGES ON *.* TO myuser@localhost IDENTIFIED BY 'password' WITH GRANT OPTION;
-===== Convert a db to UTF8 after upgrading to MySQL 4.1 =====
-   mysqldump --user=username --password=password --default-character-set=latin1 --skip-set-charset dbname > dump.sql
-   chgrep latin1 utf8 dump.sql
-   mysql --user=username --password=password --execute="DROP DATABASE dbname; CREATE DATABASE dbname; CHARACTER SET utf8 COLLATE utf8_general_ci;"
-   mysql --user=username --password=password --default-character-set=utf8 dbname < dump.sql