Welcome Guest. Please Login or Register  


You are here: Index > Webuzo > General Support > Topic : Problem after changing mysql root password



Threaded Mode | Print  

 Problem after changing mysql root password (10 Replies, Read 15033 times)
Tonyb
Group: Member
Post Group: Newbie
Posts: 11
Status:
Hello everybody!
Ok I am going to place my problem here in hope, someone had a similar problem..  or can help me.

I log in to PHPMyAdmin
change my root mysql password and also changed it in /var/webuzo/my.conf

Now I can login as root and user, but in the webuzo panel I can not create database(get error) "Error Unable to create database" ...
and the one that I created before changing the root pass, does not show up in webuzo panel.



* problem
1. can Not create database.
2. existen database don't show up, on the webuso panel.
3. database user don't show up, on the webuso panel.


*What I did. before the problem
1. changed mysql root password via PHPMYADMIN
2. CANGE mysql root password via ssh in /var/webuzo/my.conf
3. root> service mysqld restart
4. reboot my VPS.



  Tony.


IP: --   

Problem after changing mysql root password
peopleinside
Group: Member
Post Group: Super Member
Posts: 1394
Status:

Open source, web and security passionate
Thank you for posting this problem here.
Sorry i'm only a user and i have not the solution but maybe i think is important to have the possibility to change the root mysql password without this kind of problem who you are describing.

I will wait here for follow and read solution and Staff of Webuzo reply.


-----------------------
PeopleInside  :angel:

Web, security, open source passionate.
IP: --   

Problem after changing mysql root password
peopleinside
Group: Member
Post Group: Super Member
Posts: 1394
Status:

Open source, web and security passionate
If you don't receve a reply here please open a support ticket here:
https://www.softaculous.com/support/

Please, if you open a support ticket,

link at the support this discussion

and ask they to explain you the solution so if you can post here the solution for fix this, can be userfull for other user.

Thanks!


-----------------------
PeopleInside  :angel:

Web, security, open source passionate.
IP: --   

Problem after changing mysql root password
valley
Group: Webuzo Team
Post Group: Super Member
Posts: 1644
Status:
@Tonyb does your file contain any leading or trailing blank spaces ?

-----------------------
Webuzo : Single User Control Panel
Join Webuzo :
Facebook
Twitter

IP: --   

Problem after changing mysql root password
Tonyb
Group: Member
Post Group: Newbie
Posts: 11
Status:
Hello valley!

I submitted ticke and that is what the support guy ask me.

There is NO blank spaces on my.conf


I can not create a databe user
I can not see the database that I have in the Webuzo Panel.

When I log via PHPMyAdmin the database is there.

Maybe is the apps installer becuase the mysql apps was re-installed





IP: --   

Problem after changing mysql root password
valley
Group: Webuzo Team
Post Group: Super Member
Posts: 1644
Status:
Quote From : Tonyb March 18, 2014, 5:49 am
Hello valley!

I submitted ticke and that is what the support guy ask me.

There is NO blank spaces on my.conf


I can not create a databe user
I can not see the database that I have in the Webuzo Panel.

When I log via PHPMyAdmin the database is there.

Maybe is the apps installer becuase the mysql apps was re-installed


Could you please reply to the support ticket and update the root details of your server and access to your Webuzo Enduser Panel, we will resolve your issues.
Apology for the trouble caused.


-----------------------
Webuzo : Single User Control Panel
Join Webuzo :
Facebook
Twitter

IP: --   

Problem after changing mysql root password
Tonyb
Group: Member
Post Group: Newbie
Posts: 11
Status:
Hello valley!

I just updated the support ticket with the login info.



Tony.



IP: --   

Problem after changing mysql root password
valley
Group: Webuzo Team
Post Group: Super Member
Posts: 1644
Status:
Quote From : Tonyb March 18, 2014, 9:05 pm
Hello valley!

I just updated the support ticket with the login info.

Tony.


Alright !!! We shall have it resolved ASAP.


-----------------------
Webuzo : Single User Control Panel
Join Webuzo :
Facebook
Twitter

IP: --   

Problem after changing mysql root password
Tonyb
Group: Member
Post Group: Newbie
Posts: 11
Status:
Ok guys, the support guy found my problem.

When I was editing the /var/ webuzo/ my.conf file.
I  must had hit the enter key on my keyboard.

So I had
" /var/webuzo/my.conf"
plus mysql root password on the text.



1> The Mysql Root password can be change by login as root to PHPMyAdmin  with the default root password in the /var/webuzo/my.conf

General Settings

2>"Change password"

3> Now you have to change with that new password  /var/my.conf

4>  root> service mysqld restart


**There are more advance ways of changing the Mysql root password.. this is the easy ways for novice like me.

**There should be a simple ways of changing Mysql root password in the Webuzo panel.

Ps. sorry my english is not that good.




valley thanks a lot for you help.


Tony.
       


IP: --   

Problem after changing mysql root password
peopleinside
Group: Member
Post Group: Super Member
Posts: 1394
Status:

Open source, web and security passionate
Quote
**There should be a simple ways of changing Mysql root password in the Webuzo panel


I agree with that.


-----------------------
PeopleInside  :angel:

Web, security, open source passionate.
IP: --   

Problem after changing mysql root password
valley
Group: Webuzo Team
Post Group: Super Member
Posts: 1644
Status:
@Tonyb and @peopleinside thanks for the suggestion.

We shall make it available soon.

-----------------------
Webuzo : Single User Control Panel
Join Webuzo :
Facebook
Twitter

IP: --   

« Previous    Next »

Threaded Mode | Print  



Jump To :


Users viewing this topic
1 guests, 0 users.


All times are GMT. The time now is April 25, 2024, 5:21 pm.

  Powered By AEF 1.0.8 © 2007-2008 Electron Inc.Queries: 11  |  Page Created In:0.023