Problem after changing username

[myilmaz]

Hi,

I read this yesterday (http://help.directadmin.com/item.php?id=193) and i changed the username whit this command:

cd /usr/local/directadmin/scripts
./change_username.sh skybikes skybikess

After doing this, i saw a few messages like : could not found etc, which exactly i don't remember. After that i was checking the website of that username and i have a magento store: the website was giving a error message.. When i checked in report of the CMS, i saw the messages:

lib/Zend/Db/Adapter/Abstract.php(858): Varien_Db_Adapter_Pdo_Mysql->_connect()
lib/Varien/Db/Adapter/Pdo/Mysql.php(300): Zend_Db_Adapter_Pdo_Mysql->_connect()

After some research i have restarted mySQL but no results.. Websites of other usernames are not working now, whit same messages. When going to MYSQL in the user i see this message: Error connecting to MySQL: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

I changed the username whit the command already to the username before but no changes. Is there a way to switch back to the early options? Thanks all!

 

[scsi]

cd /usr/local/directadmin/custombuild
./build update
./build clean
./build mysql d

 

[nobaloney]

the problem may be as simply as that changing the username may not properly change it everywhere. Have you checked to see if the MySQL databases have had their username changed as well?

If scsi's suggestion doesn't fix it for you, then check to see what your database usernames actually are, and also check any paths in your setup scripts as they may include the old username.

Jeff