Setting the root password - Revision history

George2 at 11:35, 23 July 2015

2015-07-23T11:35:54Z

George2 at 11:34, 23 July 2015

2015-07-23T11:34:10Z

George2 at 11:32, 23 July 2015

2015-07-23T11:32:09Z

George2 at 17:48, 25 October 2014

2014-10-25T17:48:02Z

George2: Created page with " mysql> UPDATE mysql.user SET Password=PASSWORD('MyNewPass') -> WHERE User='root'; mysql> FLUSH PRIVILEGES; "

2014-10-09T08:28:19Z

Created page with "<source lang="sql"> mysql> UPDATE mysql.user SET Password=PASSWORD('MyNewPass') -> WHERE User='root'; mysql> FLUSH PRIVILEGES; </source>"

New page

<source lang="sql">
mysql> UPDATE mysql.user SET Password=PASSWORD('MyNewPass')
-> WHERE User='root';
mysql> FLUSH PRIVILEGES;
</source>

@@ Line 18: / Line 18: @@
 MariaDB [mysql]> flush privileges;
 ERROR 1146 (42S02): Table 'mysql.servers' doesn't exist
 </source>

← Older revision		Revision as of 11:34, 23 July 2015
Line 6:		Line 6:

	mysqld_safe --skip-grant-tables &		mysqld_safe --skip-grant-tables &
		+
		+
		+	mysql> use mysql;
		+	mysql> update user set password=PASSWORD("NEW-ROOT-PASSWORD") where User='root';
		+	mysql> flush privileges;
		+	mysql> quit
		+
		+
		+	===
		+	ERROR 1146 (42S02): Table 'mysql.servers' doesn't exist
		+	MariaDB [mysql]> flush privileges;
		+	ERROR 1146 (42S02): Table 'mysql.servers' doesn't exist
		+
	</source>		</source>

@@ Line 3: / Line 3: @@
      ->                   WHERE User='root';
 mysql> FLUSH PRIVILEGES;
 </source>

@@ Line 1: / Line 1: @@
-<source lang="sql">
+<source lang="text">
 mysql> UPDATE mysql.user SET Password=PASSWORD('MyNewPass')
      ->                   WHERE User='root';
 mysql> FLUSH PRIVILEGES;
 </source>