[ale] setting up WP sandbox on Ubuntu...

[Step]

I got this when attempting to locate:
/var/lib/mysql
/var/lib/mysql/mysql
/var/log/mysql
/etc/init.d/mysql
/etc/mysql
/etc/rc0.d/K20mysql
/etc/rc1.d/K20mysql
/etc/rc2.d/S20mysql
/etc/rc3.d/S20mysql
/etc/rc4.d/S20mysql
/etc/rc5.d/S20mysql
/etc/rc6.d/K20mysql
/usr/lib/perl5/auto/DBD/mysql
/usr/lib/perl5/DBD/mysql

but then went ahead and tried the install of mysql-server and mysql-client,
and got this:
sudo apt-get install mysql-server mysql-client
Password:
Reading package lists... Done
Building dependency tree... Done
The following extra packages will be installed:
  mysql-client-5.0 mysql-server-5.0
Recommended packages:
  mailx
The following NEW packages will be installed:
  mysql-client mysql-client-5.0 mysql-server mysql-server-5.0
0 upgraded, 4 newly installed, 0 to remove and 0 not upgraded.
Need to get 36.5kB/27.7MB of archives.
After unpacking 63.4MB of additional disk space will be used.
Do you want to continue [Y/n]? y
Get:1 http://security.ubuntu.com dapper-security/main mysql-client
5.0.22-0ubuntu6.06 [36.5kB]
Fetched 36.5kB in 0s (47.6kB/s)
Preconfiguring packages ...
Selecting previously deselected package mysql-client-5.0.
(Reading database ... 125052 files and directories currently installed.)
Unpacking mysql-client-5.0 (from .../mysql-
client-5.0_5.0.22-0ubuntu6.06_i386.deb) ...
Selecting previously deselected package mysql-client.
Unpacking mysql-client (from .../mysql-client_5.0.22-0ubuntu6.06_all.deb)
...
Selecting previously deselected package mysql-server-5.0.
Unpacking mysql-server-5.0 (from .../mysql-
server-5.0_5.0.22-0ubuntu6.06_i386.deb) ...
Selecting previously deselected package mysql-server.
Unpacking mysql-server (from .../mysql-server_5.0.22-0ubuntu6.06_all.deb)
...
Setting up mysql-client-5.0 (5.0.22-0ubuntu6.06) ...
Setting up mysql-client (5.0.22-0ubuntu6.06) ...
Setting up mysql-server-5.0 (5.0.22-0ubuntu6.06) ...
Stopping MySQL database server: mysqld.
Starting MySQL database server: mysqld.
.
.
.
.
.

Setting up mysql-server (5.0.22-0ubuntu6.06) ...
.
step at step-desktop:/$ .
.
.
.
.
.
.
...failed or took more than 6s.
        Please take a look at the syslog.
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket
'/var/run/mysqld/mysqld.sock' (2)'
Check that mysqld is running and that the socket:
'/var/run/mysqld/mysqld.sock' exists!

Which I'm pretty sure goes to show that I still don't know what I'm doing.
:)  So I was running into this socket error earlier.  Using the "locate"
trick you mentioned, I learned where the syslog is and found this at the
end:
Aug 26 20:41:32 localhost -- MARK --
Aug 26 20:53:26 localhost mysqld_safe[1891]: PLEASE REMEMBER TO SET A
PASSWORD FOR THE MySQL root USER !
Aug 26 20:53:26 localhost mysqld_safe[1891]: To do so, start the server,
then issue the following commands:
Aug 26 20:53:26 localhost mysqld_safe[1891]: /usr/bin/mysqladmin -u root
password 'new-password'
Aug 26 20:53:26 localhost mysqld_safe[1891]: /usr/bin/mysqladmin -u root -h
step-desktop password 'new-password'
Aug 26 20:53:26 localhost mysqld_safe[1891]: See the manual for more
instructions.
Aug 26 20:53:26 localhost mysqld_safe[1891]:
Aug 26 20:53:26 localhost mysqld_safe[1891]: NOTE:  If you are upgrading
from a MySQL <= 3.22.10 you should run
Aug 26 20:53:26 localhost mysqld_safe[1891]: the
/usr/bin/mysql_fix_privilege_tables. Otherwise you will not be
Aug 26 20:53:26 localhost mysqld_safe[1891]: able to use the new GRANT
command!
Aug 26 20:53:26 localhost mysqld_safe[1891]:
Aug 26 20:53:26 localhost mysqld_safe[1891]: Please report any problems with
the /usr/bin/mysqlbug script!
Aug 26 20:53:26 localhost mysqld_safe[1891]:
Aug 26 20:53:26 localhost mysqld_safe[1891]: The latest information about
MySQL is available on the web at
Aug 26 20:53:26 localhost mysqld_safe[1891]: http://www.mysql.com
Aug 26 20:53:26 localhost mysqld_safe[1891]: Support MySQL by buying
support/licenses at http://shop.mysql.com
Aug 26 20:53:30 localhost mysqld_safe[2088]: started
Aug 26 20:53:31 localhost mysqld[2093]: 060826 20:53:31  InnoDB: Started;
log sequence number 0 43655
Aug 26 20:53:31 localhost mysqld[2093]: 060826 20:53:31 [ERROR] Can't start
server: Bind on TCP/IP port: Address already in use
Aug 26 20:53:31 localhost mysqld[2093]: 060826 20:53:31 [ERROR] Do you
already have another mysqld server running on port: 3306 ?
Aug 26 20:53:31 localhost mysqld[2093]: 060826 20:53:31 [ERROR] Aborting
Aug 26 20:53:31 localhost mysqld[2093]:
Aug 26 20:53:32 localhost mysqld[2093]: 060826 20:53:32  InnoDB: Starting
shutdown...
Aug 26 20:53:34 localhost mysqld[2093]: 060826 20:53:34  InnoDB: Shutdown
completed; log sequence number 0 43655
Aug 26 20:53:34 localhost mysqld[2093]: 060826 20:53:34 [Note]
/usr/sbin/mysqld: Shutdown complete
Aug 26 20:53:34 localhost mysqld[2093]:
Aug 26 20:53:34 localhost mysqld_safe[2132]: ended
Aug 26 20:53:47 localhost /etc/init.d/mysql[2252]: 0 processes alive and
'/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Aug 26 20:53:47 localhost /etc/init.d/mysql[2252]: ^G/usr/bin/mysqladmin:
connect to server at 'localhost' failed
Aug 26 20:53:47 localhost /etc/init.d/mysql[2252]: error: 'Can't connect to
local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Aug 26 20:53:47 localhost /etc/init.d/mysql[2252]: Check that mysqld is
running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Aug 26 20:53:47 localhost /etc/init.d/mysql[2252]:

So it looks to me like I might have already had a mysqld (daemon?) running?
So do I shut the old one down?  Or how do I fix the socket error?

On 8/26/06, Brian D. Pitts <bpitts at learnlink.emory.edu> wrote:
>
>  *Atlanta Linux Enthusiasts <ale at ale.org> on Sat Aug 26 2006 at 20:16
> -0500 wrote:
> *Right now when I try "sudo mysql -u root -p" (I only know what half of
> that means), I get "sudo: mysql: command not found".  How do I go about
> troubleshooting that?  I(t's sad, but I don't even know where to start now -
> I'm afraid too much googling has left me very confused......)
>
>
> I would make sure that both the packages mysql-client and mysql-server are
> installed; try installing them again with sudo apt-get install mysql-server
> mysql client. If you didn't remove XAMPP, a copy of the mysql client may be
> installed somewhere outside your path; you could try to locate it with the
> command locate -r mysql$.
> Sudo lets you run a command with root privileges. mysql is the command
> you're trying to run, it lets you interact with your mysql server. -u root
> specifies that you want to connect to the database as the mysql root user.
> -p means you want to be prompted for the mysql root user's password.
>
> -Brian
>
> _______________________________________________
> Ale mailing list
> Ale at ale.org
> http://www.ale.org/mailman/listinfo/ale
>
>
-------------- next part --------------
An HTML attachment was scrubbed...