change mysql root password

You are here: Index > Webuzo > General Support > Topic : change mysql root password

Threaded Mode | Print

change mysql root password (19 Replies, Read 31979 times)

view	# February 11, 2014, 1:52 am
Group: Member Post Group: Working Newbie Posts: 76 Status:	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?
IP: --

change mysql root password

valley	# February 11, 2014, 5:57 am \| Post: 1
Group: Webuzo Team Post Group: Super Member Posts: 1644 Status:	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
IP: --

change mysql root password

frewty	# February 11, 2014, 10:58 am \| Post: 2
Group: Member Post Group: Newbie Posts: 26 Status:	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
IP: --

change mysql root password

view	# February 11, 2014, 12:31 pm \| Post: 3
Group: Member Post Group: Working Newbie Posts: 76 Status:	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?
IP: --

change mysql root password

frewty	# February 11, 2014, 3:22 pm \| Post: 4
Group: Member Post Group: Newbie Posts: 26 Status:	Hi, Did you keep the original install file as it will have the default password in it?
IP: --

change mysql root password

view	# February 11, 2014, 3:40 pm \| Post: 5
Group: Member Post Group: Working Newbie Posts: 76 Status:	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.
IP: --

change mysql root password

valley	# February 12, 2014, 5:24 am \| Post: 6
Group: Webuzo Team Post Group: Super Member Posts: 1644 Status:	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
IP: --

change mysql root password

sameed	# October 22, 2014, 10:18 am \| Post: 7
Group: Member Post Group: Newbie Posts: 11 Status:	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)
IP: --

change mysql root password

valley	# October 22, 2014, 10:41 am \| Post: 8
Group: Webuzo Team Post Group: Super Member Posts: 1644 Status:	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
IP: --

change mysql root password

sameed	# October 22, 2014, 10:55 am \| Post: 9
Group: Member Post Group: Newbie Posts: 11 Status:	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)
IP: --

change mysql root password

valley	# October 22, 2014, 11:01 am \| Post: 10
Group: Webuzo Team Post Group: Super Member Posts: 1644 Status:	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
IP: --

change mysql root password

sameed	# October 22, 2014, 11:13 am \| Post: 11
Group: Member Post Group: Newbie Posts: 11 Status:	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)
IP: --

change mysql root password

valley	# October 22, 2014, 11:21 am \| Post: 12
Group: Webuzo Team Post Group: Super Member Posts: 1644 Status:	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
IP: --

change mysql root password

sameed	# October 22, 2014, 11:37 am \| Post: 13
Group: Member Post Group: Newbie Posts: 11 Status:	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
IP: --

change mysql root password

peopleinside	# October 22, 2014, 11:39 am \| Post: 14
Group: Member Post Group: Super Member Posts: 1394 Status: Open source, web and security passionate	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 Web, security, open source passionate.
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, 12:35 pm.

Powered By AEF 1.0.8 © 2007-2008 Electron Inc.

Queries: 11 | Page Created In:0.025