MYSQL root password change
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
- 347 Beta Program
- 2.1K Nebula
- 115 Nebula Ideas
- 77 Nebula Status and Incidents
- 5K Security
- 44 USG FLEX H Series
- 246 Security Ideas
- 1.2K Switch
- 64 Switch Ideas
- 900 WirelessLAN
- 33 WLAN Ideas
- 5.8K Consumer Product
- 204 Service & License
- 326 News and Release
- 71 Security Advisories
- 21 Education Center
- 5 [Campaign] Zyxel Network Detective
- 1.8K FAQ
- 832 Nebula FAQ
- 402 Security FAQ
- 219 Switch FAQ
- 190 WirelessLAN FAQ
- 45 Consumer Product FAQ
- 136 Service & License FAQ
- 34 Documents
- 34 Nebula Monthly Express
- 71 About Community
- 61 Security Highlight