Softaculous

Topic : change mysql root password

Page 1 of 2

Posted By: view on February 11, 2014, 1:52 am

After changing mysql root password from /var/webuzo/my.conf now i cannot to login in phpmyadmin and cannot to create any new database.I`m tryed with mysql reinstallation but that was not help.

How to solve problem with mysql root password?

Posted By: valley on February 11, 2014, 5:57 am | Post: 1

Changing the contents of the file /var/webuzo/my.conf does not change the password to the MySQL root user.

You will have to login to mysql safe mode to change the password to the root user.

Alternately, if you remember the old password, the process can be simplified.

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

Posted By: frewty on February 11, 2014, 10:58 am | Post: 2

Hi, If you have never changed it - do you not have the Installation log on the server still with the password in it? although this should have been deleted after installation. Thanks,Anthony

Posted By: view on February 11, 2014, 12:31 pm | Post: 3

I have a problem with starting mysql in safe mode

[root@server ~]# mysqld_safe --skip-grant-tables &
[1] 15463
[root@server ~]# 140211 12:01:51 mysqld_safe Logging to '/var/log/mysqld.log'.
140211 12:01:51 mysqld_safe Starting mysqld daemon with databases from /var/lib/ mysql
140211 12:01:53 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ende d
[root@server ~]# mysql -u root
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
[1]+ Done mysqld_safe --skip-grant-tables

Do you have any solution for this or i will must to reinstall webuzo?

Posted By: frewty on February 11, 2014, 3:22 pm | Post: 4

Hi, Did you keep the original install file as it will have the default password in it?

Posted By: view on February 11, 2014, 3:40 pm | Post: 5

No,i did not keep original file.Server is empty so for me quickest solution was to reinstall webuzo and that was solve my problem.

Posted By: valley on February 12, 2014, 5:24 am | Post: 6

Quote From : hosting022 February 11, 2014, 3:40 pm

No,i did not keep original file.Server is empty so for me quickest solution was to reinstall webuzo and that was solve my problem.

You could have changed the password easily using safe mode.

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

Posted By: sameed on October 22, 2014, 10:18 am | Post: 7

we have same problem after run mysql in safe mode and run this command its show error
how to solve please help me

[root@server ~]# mysql -u root

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)

Posted By: valley on October 22, 2014, 10:41 am | Post: 8

Yo can refer to this
http://www.rackspace.com/knowledge_center/article/mysql-resetting-a-lost-mysql-root-password

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

Posted By: sameed on October 22, 2014, 10:55 am | Post: 9

we get error
mysql -u root
after run above command show me error
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)

Posted By: valley on October 22, 2014, 11:01 am | Post: 10

Please refer to the guide provided earlier, step by step.

Path to MySQL binaries is located at /usr/local/apps/mysql/bin

Hope it helps

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

Posted By: sameed on October 22, 2014, 11:13 am | Post: 11

sir i work on step by step but show error see this where problem

Code
[root@dedi-fr-28549 ~]# sudo /etc/init.d/mysqld stop

Shutting down MySQL. SUCCESS!

[root@dedi-fr-28549 ~]# sudo mysqld_safe --skip-grant-tables &

[1] 4803

[root@dedi-fr-28549 ~]# 141022 10:52:26 mysqld_safe Logging to '/var/log/mysqld.                                                                                                                                  log'.

141022 10:52:26 mysqld_safe Starting mysqld daemon with databases from /var/lib/                                                                                                                                  mysql

141022 10:52:27 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ende                                                                                                                                  d

[root@dedi-fr-28549 ~]# mysql -u root

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)

[1]+  Done                    sudo mysqld_safe --skip-grant-tables

[root@dedi-fr-28549 ~]# sudo mysqld_safe --skip-grant-tables

141022 10:54:23 mysqld_safe Logging to '/var/log/mysqld.log'.

141022 10:54:23 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql

141022 10:54:24 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended

[root@dedi-fr-28549 ~]# mysql -u root

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)

Posted By: valley on October 22, 2014, 11:21 am | Post: 12

Sir you can check the logs here to learn more about the issue
/var/log/mysqld.log

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

Posted By: sameed on October 22, 2014, 11:37 am | Post: 13

we have these log file

Code

141022 11:07:55 mysqld_safe mysqld from pid file /var/lib/mysql/mysqld.pid ended

141022 11:08:02 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql

141022 11:08:02 InnoDB: The InnoDB memory heap is disabled

141022 11:08:02 InnoDB: Mutexes and rw_locks use GCC atomic builtins

141022 11:08:02 InnoDB: Compressed tables use zlib 1.2.3

141022 11:08:02 InnoDB: Initializing buffer pool, size = 128.0M

141022 11:08:02 InnoDB: Completed initialization of buffer pool

141022 11:08:03 InnoDB: highest supported file format is Barracuda.

141022 11:08:03  InnoDB: Waiting for the background threads to start

141022 11:08:04 InnoDB: 5.5.40 started; log sequence number 14141133621

141022 11:08:04 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306

141022 11:08:04 [Note]   - '0.0.0.0' resolves to '0.0.0.0';

141022 11:08:04 [Note] Server socket created on IP: '0.0.0.0'.

141022 11:08:04 [Note] Event Scheduler: Loaded 0 events

141022 11:08:04 [Note] /usr/local/apps/mysql/bin/mysqld: ready for connections.

Version: '5.5.40-log'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution

141022 11:19:35 [Note] /usr/local/apps/mysql/bin/mysqld: Normal shutdown

Posted By: peopleinside on October 22, 2014, 11:39 am | Post: 14

Maybe canbe implemeted a changing root mysql in end user of webuzo like SSH root password is now editable by webuzo panel?

Will be great.

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

:angel:

Web, security, open source passionate.

Powered By AEF 1.0.8 © 2007-2008 Electron Inc.