Differences

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

--- mysql [2006/05/29 09:42]
greebo
+++ 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;