changed hostname, now major mysql problems

[t17169]

For 5 days, been trying to configure my VPS so I can get sites up...not happening. Went thru a dns loop, finally resolved. Host name changed. Next was the seemingly rite of passage issue of PHPmyadmin, wrong username, permission denied. Using solutions suggested here turned out not to be my problem.

MySql path in former hostname/nameserver and I do not know how to change.

Originally account name and therefore hostname was elcascoantiguo.com...using server nameservers after adding two dot hostname, became system elcascoantiguo.com and panama.vzservers.com <---OLD!

However, now, system is mediodiablo.com / hostname panama.mediodiablo.com / nameserver ns1 and 2.mediodiablo.com

MySql install is good, but paths are now wrong. See below. how do I resolve?

[email protected] [~]# ls -l /var/lib/mysql
total 20563
drwxr-x--x 9 mysql mysql 1024 Jan 31 23:29 ./
drwxr-xr-x 11 root root 1024 Jan 27 23:40 ../
drwx------ 2 mysql mysql 1024 Jan 30 03:26

Cpanel::Mysql\=HASH(0x81ad0f8)/
drwx------ 2 mysql mysql 1024 Jan 31 16:37

Cpanel::Mysql\=HASH(0x8316e10)/
drwx------ 2 mysql mysql 1024 Jan 29 13:35

Cpanel::Mysql\=HASH(0x8316e78)/
drwx------ 2 mysql mysql 1024 Jan 31 23:29

Cpanel::Mysql\=HASH(0x8316e80)/
-rw-rw---- 1 mysql mysql 2039 Jan 31 02:13 elcascoantiguo.com.err
-rw-rw---- 1 mysql mysql 6 Jan 29 12:23 elcascoantiguo.com.pid
-rw-rw---- 1 mysql mysql 25088 Jan 29 12:23 ib_arch_log_0000000000
-rw-rw---- 1 mysql mysql 5242880 Jan 31 02:13 ib_logfile0
-rw-rw---- 1 mysql mysql 5242880 Jan 29 12:23 ib_logfile1
-rw-rw---- 1 mysql mysql 10485760 Jan 29 12:23 ibdata1
drwx------ 2 mysql mysql 1024 Jan 27 23:40 mysql/
srwxrwxrwx 1 mysql mysql 0 Jan 31 02:13 mysql.sock=
-rw-rw---- 1 mysql mysql 273 Jan 31 02:13

panama.vzservers.com.err
-rw-rw---- 1 mysql mysql 6 Jan 31 02:13

panama.vzservers.com.pid
drwx------ 2 mysql mysql 1024 Jan 27 23:40 phpmyadmin/
drwx------ 2 mysql mysql 1024 Jan 27 23:40 test/
[email protected] [~]#

 

[dalem]

for your hostname check your

/etc/hosts file and correct as necessary

for your root phpmyadmin access

reset MySQL Root Password in whm and insure threre are no ""'s around the passworrd in
/root/.my.cnf

 

[t17169]

tried /etc/hosts

permission denied

 

[dalem]

you need to use an editor vi, pico, nano

 

[madaboutlinux]

You are on a VPS so you cannot change the hostname from your end. The Hostname for your VPS can be changed from the main VPS server on which your vps is created. You will have to ask your Hosting company to change the hostname for you.

Here is the command to change the hostname :-
vzctl set VEID --hostname your.hostname.name --save
where,
VEID is your vps ID.

 

[taotoon]

Thanks ShekHar to tell me that.. very good info.