mysql primer

[zander]

hi,

can someone point me to a primer on mysql please? i need to setup mysql to use wordpress on bubba.

is mysql already setup on bubba?

please advise,

thank you.

[HeSitated]

Log in through SSH and execute:

Code: Select all

ps aux|grep mysql

What does it say?

[asparak]

MySQL is installed by default. Things like squeezecenter and Album use it

[Kiff]

log in with "mysql -u root" (the root password is empty be default)

http://www.webdevelopersnotes.com/tutor ... abase.php3

[zander]

Log in through SSH and execute:

Code: Select all

ps aux|grep mysql

What does it say?

bubba:/home/af# ps aux|grep mysql
root 2068 0.0 0.5 3460 1532 ? S 2009 0:00 /bin/sh /usr/bin/mysqld_safe
mysql 2107 0.3 14.3 130188 36876 ? Sl 2009 574:25 /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 2108 0.0 0.2 1784 584 ? S 2009 0:00 logger -p daemon.err -t mysqld_safe -i -t mysqld
root 31543 0.0 0.3 3088 804 pts/0 S+ 15:16 0:00 grep mysql
bubba:/home/af#

[Binkem]

You might want to install PHPmyadmin

http://forum.excito.net/viewtopic.php?f ... dmin#p8976

This makes using PHP a lot easier if you're not a linux wizard.

[HeSitated]

Code: Select all

ps aux|grep mysql

This lists all running processes with the word mysql in it...

mysql 2107 0.3 14.3 130188 36876 ? Sl 2009 574:25 /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

So mysql is running on your B2.