Re: [cobalt-developers] mysql question

[Herb Rubin <herbr@xxxxxxxxxxxx>]

Shawn,

The password should be right next to the -p no space:

mysql -u root -ppassword

for example if the password was "abc123"

mysql -u root -pabc123

Herb


On Thu, 2003-10-23 at 15:17, Shawn Guillemette wrote:
> I recently have restored my cobalt RAQ4 to factor condition. After
> installing all the updates for the service that I use on the device I
> attempted to install mysql with this RMP
> 
> [root admin]# ls
> mail  MySQL-server-4.0.15-0.i386.rpm
> 
> 
> I used rpm -i MySQL-server-4.0.15-0.i386.rpm
> 
> Now when attempting to set the mysql root passwd or attempting to connect to
> the mysql server I get this
> 
> 
> [root admin]# mysqladmin -u root -p password password
> Enter password:
> mysqladmin: connect to server at 'localhost' failed
> error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock'
> (111)'
> Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists!
> 
> mysql Seems to be running..
> 
> 
> [root admin]# ps -ax | grep mysql
> 26833 pts/0    S      0:00 sh /usr/bin/safe_mysqld
> 26863 pts/0    S      0:00
> /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql
> 26865 pts/0    S      0:00
> /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql
> 26866 pts/0    S      0:00
> /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql
> 26867 pts/0    S      0:00
> /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql
> 26868 pts/0    S      0:00
> /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql
> 26869 pts/0    S      0:00
> /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql
> 26870 pts/0    S      0:00
> /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql
> 26871 pts/0    S      0:00
> /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql
> 26872 pts/0    S      0:00
> /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql
> 26873 pts/0    S      0:00
> /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql
> 
> 
> 
> and the /tmp/mysql.sock file seems to be there with the correct permissions
> 
> [root /tmp]# ls -la | grep mysql.sock
> srwxrwxrwx    1 mysql    root            0 Oct 21 16:08 mysql.sock
> [root /tmp]#
> 
> 
> the content of the file is blank though..
> 
> 
> Any help would be great... I also read in forums that this question has been
> asked a lot... how ever I was unable to locate a solution ..
> 
> 
> thank you
> Shawn
> 
> _______________________________________________
> cobalt-developers mailing list
> cobalt-developers@xxxxxxxxxxxxxxx
> http://list.cobalt.com/mailman/listinfo/cobalt-developers
> 
-- 
Herb Rubin                 Pathfinders Software
herbr@xxxxxxxxxxxx         http://www.pfinders.com
phone: 650-692-9220        fax:   650-692-9250