|
|
Joined: Jul 2002
Posts: 135
Journeyman
|
Journeyman
Joined: Jul 2002
Posts: 135 |
Okay, I'm logged in as an administrator and in the command prompt but it wont let me enter the 'MySql MySql' section anymore. Even when it did let me in it didn't let me change the root password. Any idea?
|
|
|
|
Joined: Oct 2000
Posts: 2,223
Veteran
|
Veteran
Joined: Oct 2000
Posts: 2,223 |
it's lower case. mysql.
Are you using the right syntax?
##: mysql -u username -p
enter password: password
Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 781935 to server version: 4.0.4-beta
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
> use mysql; Database changed
> update user set password=password("newpassword") where user='root'; Query OK, 2 rows effected (0.02 sec)
> flush privileges; Query OK, 0 rows affected (0.02 sec)
> \q Bye
##:
Picture perfect penmanship here.
|
|
|
|
Joined: Oct 2000
Posts: 2,223
Veteran
|
Veteran
Joined: Oct 2000
Posts: 2,223 |
P.S. that was the syntax for a 3.23.x series MySQL. If you are using a 4 series the syntax will differ somewhat.
Picture perfect penmanship here.
|
|
|
|
Joined: Jul 2002
Posts: 135
Journeyman
|
Journeyman
Joined: Jul 2002
Posts: 135 |
after the
update user set password=("****") where user='root';
setp I got this error:
ERROR 1146: Table 'mysql.user' doesn't exist
|
|
|
Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.
Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
|
|
Posts: 449
Joined: February 2008
|
|
Forums63
Topics37,573
Posts293,925
Members13,849
|
Most Online5,166 Sep 15th, 2019
|
|
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
|
|
|
|
|