Raible's Wiki

Raible Designs
Wiki Home
News
Recent Changes

AppFuse

Homepage
  - Korean
  - Chinese
  - Italian
  - Japanese

QuickStart Guide
  - Chinese
  - French
  - German
  - Italian
  - Korean
  - Portuguese
  - Spanish
  - Japanese

User Guide
  - Korean
  - Chinese

Tutorials
  - Chinese
  - German
  - Italian
  - Korean
  - Portuguese
  - Spanish

FAQ
  - Korean

Latest Downloads

Other Applications

Struts Resume
Security Example
Struts Menu

Set your name in
UserPreferences

Referenced by
Main
TextFormattingRules
WhatIsWiki




JSPWiki v2.2.33

[RSS]


Hide Menu

SandBox
Search Wiki:
Your trail:

Difference between version 297 and version 296:

At line 30 added 1 line.
* [4] Set the root password
At line 36 removed 4 lines.
At line 51 added 1 line.
At line 53 added 1 line.
At line 56 changed 1 line.
database.admin.password=myrootpassword
database.admin.password=myrootpassword
At line 57 added 1 line.
At line 85 changed 3 lines.
$ mysql -u root
mysql> use mysql;
Database changed
{{{
$ mysql -u root
mysql> use mysql;
Database changed
At line 89 changed 1 line.
mysql> select user, host, password from user where user = "root";
mysql> select user, host, password from user where user = "root";
At line 91 changed 9 lines.
{{{
+------+-----------+----------+
| user | host | password |
+------+-----------+----------+
| root | localhost | |
| root | mypc | |
| root | % | |
+------+-----------+----------+
3 rows in set (0.00 sec)
+------+-----------+----------+
| user | host | password |
+------+-----------+----------+
| root | localhost | |
| root | mypc | |
| root | % | |
+------+-----------+----------+
3 rows in set (0.00 sec)
At line 110 changed 1 line.
mysqladmin -u root -p shutdown
mysqladmin -u root -p shutdown
At line 117 changed 2 lines.
(UNIX) killall mysqld
(Windows) Use task manager or stop the mysqld service
(UNIX) killall mysqld
(Windows) Use task manager or stop the mysqld service
At line 126 changed 1 line.
${MYSQL_HOME}/bin/mysqld_safe --skip-grant-tables &
${MYSQL_HOME}/bin/mysqld_safe --skip-grant-tables &
At line 131 changed 5 lines.
mysql -u root
use mysql;
delete from user where user='root';
commit;
FLUSH PRIVILEGES;
mysql -u root
use mysql;
delete from user where user='root';
commit;
FLUSH PRIVILEGES;
At line 142 changed 10 lines.
mysql -u root
use mysql;
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;
GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION;
FLUSH PRIVILEGES;
GRANT ALL PRIVILEGES ON *.* TO 'root'@'mypc' WITH GRANT OPTION;
FLUSH PRIVILEGES;
quit;
mysql -u root
use mysql;
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;
GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION;
FLUSH PRIVILEGES;
GRANT ALL PRIVILEGES ON *.* TO 'root'@'mypc' WITH GRANT OPTION;
FLUSH PRIVILEGES;
quit;
At line 166 changed 1 line.
it is likely you need to perform the steps in [3].
it is likely you need to perform the steps in [3]. If you are up and running,
you should not set the root password as described in [4].
At line 173 changed 2 lines.
Invalid authorization specification message from server:
"Access denied for user: 'test@mypc' (Using password: YES)"
Invalid authorization specification message from server:
"Access denied for user: 'test@mypc' (Using password: YES)"
At line 177 removed 2 lines.
At line 184 changed 3 lines.
create database if not exists appfuse;
grant all privileges on appfuse.* to test@localhost identified by "test";
grant all privileges on appfuse.* to test@mypc identified by "test";
create database if not exists appfuse;
grant all privileges on appfuse.* to test@localhost identified by "test";
grant all privileges on appfuse.* to test@mypc identified by "test";
At line 187 added 21 lines.
!!Set the root password [#4]
To set the root password, type the following commands :
{{{
$ mysql -u root
mysql> use mysql;
Database changed
}}}
Now we want to set the password field for any root user records in the users table.
Type this command:
{{{
UPDATE user SET Password=PASSWORD('myrootpassword')
WHERE User='root';
FLUSH PRIVILEGES;
}}}
Where myrootpassword is your root user password.

Back to SandBox, or to the Page History.