MYSQL root password change
Options
Roger_Waldrip
Posts: 10 Freshman Member
I want to change the MYSQL root password on my Zyxel NAS540 (and also whatever changes I need to make to phpMyAdmin to then access the MYSQL server).
I have entered the following line into mysql sql command box from within the phpMyAdmin app but just get an error. Where password is 1234 and the making a new password.
I get the following error. #1064
Also, what changes do I need to make to phpMyAdmin to make it work with the new password.
Thanks
Roger L. Waldrip
#NAS_May
I have entered the following line into mysql sql command box from within the phpMyAdmin app but just get an error. Where password is 1234 and the making a new password.
mysqladmin --user=root --password=oldpassword password "newpassword"
I get the following error. #1064
Also, what changes do I need to make to phpMyAdmin to make it work with the new password.
Thanks
Roger L. Waldrip
#NAS_May
0
Comments
-
0
-
Where on/in the phpMyAdmin web app do I do this? I can bring the phpMyAdmin page up and it seems it work, but I see no where to change the root password.0
-
After login phpMyadmin, you can see the item as "Change Password", then click it to change your mySQL password.
Or you can go "Users" and "Edit Privileges" for root
This part should meet your requirement.0 -
Got it. I don't know how I missed it. Thank you so much.0
Categories
- All Categories
- 394 Beta Program
- 2.1K Nebula
- 116 Nebula Ideas
- 78 Nebula Status and Incidents
- 5.1K Security
- 51 USG FLEX H Series
- 247 Security Ideas
- 1.3K Switch
- 70 Switch Ideas
- 907 WirelessLAN
- 34 WLAN Ideas
- 5.9K Consumer Product
- 210 Service & License
- 332 News and Release
- 71 Security Advisories
- 21 Education Center
- 5 [Campaign] Zyxel Network Detective
- 1.9K FAQ
- 880 Nebula FAQ
- 415 Security FAQ
- 221 Switch FAQ
- 195 WirelessLAN FAQ
- 46 Consumer Product FAQ
- 137 Service & License FAQ
- 34 Documents
- 34 Nebula Monthly Express
- 72 About Community
- 63 Security Highlight