Re: [cobalt-developers] mysql question

["Tim de Vries" <devriest@xxxxxxxxx>]

Hi Shawn,

It sounds like you don't have a problem running the apps, so it would seem
as though your path is okay.

So, for your next step, you have to make a symbolic link to the mysql.sock
in the directory that mysql is looking for it -- usually /tmp/mysql.sock,
but you can set it mysql to point to its' actual location by looking at the
options for mysqld.

Secondly, if you aren't able to login to mysql after the mysqld app is
running, you may have to start up mysqladmin using the --skip-grant-tables
parameter.  Finally if you are able to get into mysql, but your root
password (mysql, not su) will not let you login, then you have to execute
these SQL queries:

1.) UPDATE user SET Password=PASSWORD('your_new_root_mysql_pass') WHERE
User='root';
2.) FLUSH PRIVILEGES;
3.) quit

once those are done, restart mysqld using whichever scripts, or method you
prefer....
on my RaQ550, for example, I run /etc/init.d/mysql stop and then
/etc/init.d/mysql start

Once that is done, you should be able to login to mysql or mysqladmin using
the line from your post:

[root admin]# mysqladmin -u root -p password password

Hope that helps.  If not, feel free to contact me directly at
devriest@xxxxxxxxx and I'll see if I can help you further.

Regards,

Tim de Vries

----- Original Message -----
From: "Shawn Guillemette" <shawn@xxxxxxxxxxxxxxx>
To: <cobalt-developers@xxxxxxxxxxxxxxx>
Sent: Thursday, October 23, 2003 4:17 PM
Subject: [cobalt-developers] mysql question


> 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