Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > HOWTO-Related Questions

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 9th July 2007, 16:04
paul55 paul55 is offline
Junior Member
 
Join Date: Apr 2007
Location: Greece
Posts: 4
Thanks: 1
Thanked 0 Times in 0 Posts
Default The Perfect Setup - Debian Etch (Debian 4.0) mysql question

Hi all i have just installed debian etch following that howto but i have a problem about configuring the mysql server.Exactly when i try to run
Code:
 mysqladmin -h myhostname.mydomainname -u root password my-mysqlrootpassword
i get this error:
Code:
mysqladmin: connect to server at 'medic3.medichome' failed
error: 'Lost connection to MySQL server at 'reading initial communication packet', system error: 113'
.The server is running
Code:
medic3:/home/paul555# ps -ef |grep mysql
root      2154     1  0 15:29 ?        00:00:00 /bin/sh /usr/bin/mysqld_safe
mysql     2191  2154  0 15:29 ?        00:00:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-external-locking --port=3306 --socket=/var/run/mysqld/mysqld.sock
root      2192  2154  0 15:29 ?        00:00:00 logger -p daemon.err -t mysqld_safe -i -t mysqld
root      2648  2626  0 16:01 pts/0    00:00:00 grep mysql
and i have created ok the root password previously with
Code:
mysqladmin -u root password my-mysqlrootpassword
.Does anyone have an idea?
Reply With Quote
Sponsored Links
  #2  
Old 9th July 2007, 16:57
planet_fox planet_fox is offline
Senior Member
 
Join Date: Jun 2006
Location: Munic
Posts: 308
Thanks: 14
Thanked 8 Times in 6 Posts
Send a message via Skype™ to planet_fox
Default

Do this or reinstall mysql and do again
Quote:
/etc/init.d/mysql restart
Reply With Quote
  #3  
Old 10th July 2007, 10:46
paul55 paul55 is offline
Junior Member
 
Join Date: Apr 2007
Location: Greece
Posts: 4
Thanks: 1
Thanked 0 Times in 0 Posts
Default

I reinstall mysql and restarted it but still the same error
Reply With Quote
  #4  
Old 10th July 2007, 14:47
planet_fox planet_fox is offline
Senior Member
 
Join Date: Jun 2006
Location: Munic
Posts: 308
Thanks: 14
Thanked 8 Times in 6 Posts
Send a message via Skype™ to planet_fox
Default

hm what is when you do this

Quote:
mysqladmin -h localhost -u root password yourrootsqlpassword
Reply With Quote
The Following User Says Thank You to planet_fox For This Useful Post:
adamassasda291 (5th June 2013)
  #5  
Old 10th July 2007, 16:24
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,747 Times in 2,578 Posts
Default

What's the output of
Code:
netstat -tap
?
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #6  
Old 11th July 2007, 10:37
paul55 paul55 is offline
Junior Member
 
Join Date: Apr 2007
Location: Greece
Posts: 4
Thanks: 1
Thanked 0 Times in 0 Posts
Default

When i run
Code:
mysqladmin -h localhost -u root password myrootsqlpassword
i get
Code:
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'
but when i run
Code:
mysqladmin -hlocalhost -u root -p version
it connects
Code:
mysqladmin  Ver 8.41 Distrib 5.0.32, for pc-linux-gnu on i486
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license

Server version          5.0.32-Debian_7etch1-log
Protocol version        10
Connection              Localhost via UNIX socket
UNIX socket             /var/run/mysqld/mysqld.sock
Uptime:                 1 hour 13 min 19 sec

Threads: 1  Questions: 141  Slow queries: 0  Opens: 135  Flush tables: 1  Open tables: 17  Queries per second avg: 0.032
while when i run
Code:
mysqladmin -h myhostname -u root -p version
i get
Code:
mysqladmin: connect to server at 'medic3' failed
error: 'Access denied for user 'root'@'medic3.medichome' (using password: YES)'
Code:
netstat -tap
gives
Code:
# netstat -tap
Active Internet connections (servers and established)
Proto Recv-Q Send-Q Local Address           Foreign Address         State       PID/Program name
tcp        0      0 *:4137                  *:*                     LISTEN     2450/rpc.statd
tcp        0      0 *:mysql                 *:*                     LISTEN     2148/mysqld
tcp        0      0 *:sunrpc                *:*                     LISTEN     1828/portmap
tcp        0      0 *:auth                  *:*                     LISTEN     2321/inetd
tcp        0      0 *:ftp                   *:*                     LISTEN     2481/proftpd: (acce
tcp        0      0 192.168.123.168:domain  *:*                     LISTEN     2049/named
tcp        0      0 localhost.locald:domain *:*                     LISTEN     2049/named
tcp        0      0 *:smtp                  *:*                     LISTEN     2381/master
tcp        0      0 localhost.localdoma:953 *:*                     LISTEN     2049/named
tcp6       0      0 *:imaps                 *:*                     LISTEN     2293/couriertcpd
tcp6       0      0 *:pop3s                 *:*                     LISTEN     2311/couriertcpd
tcp6       0      0 *:pop3                  *:*                     LISTEN     2298/couriertcpd
tcp6       0      0 *:imap2                 *:*                     LISTEN     2281/couriertcpd
tcp6       0      0 *:www                   *:*                     LISTEN     2513/apache2
tcp6       0      0 *:domain                *:*                     LISTEN     2049/named
tcp6       0      0 *:ssh                   *:*                     LISTEN     2410/sshd
tcp6       0      0 *:smtp                  *:*                     LISTEN     2381/master
tcp6       0      0 ip6-localhost:953       *:*                     LISTEN     2049/named
tcp6       0      0 *:https                 *:*                     LISTEN     2513/apache2
tcp6       0      0 ::ffff:192.168.123.:ssh ::ffff:192.168.123:4113 ESTABLISHED2560/sshd: paul555

Last edited by paul55; 11th July 2007 at 11:49.
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
The Perfect Xen 3.1.0 Setup For Debian Etch (i386) ko0nz HOWTO-Related Questions 8 13th November 2007 21:48
Do you have The Perfect Setup - Debian Etch ? Dekalb Installation/Configuration 2 2nd June 2007 01:16
Question about the The Perfect Setup - Debian Sarge (3.1) page 3 paulley Installation/Configuration 2 1st December 2006 02:33
perfect setup suse 10 - phpmyadmin & mysql question reddog Server Operation 7 17th June 2006 13:59
Perfect Setup Debian Sarge 64bits Pc question toyito HOWTO-Related Questions 1 19th May 2006 21:32


All times are GMT +2. The time now is 18:29.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.