Page 1 of 1
mysql primer
Posted: 09 Feb 2010, 04:00
by 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.
Re: mysql primer
Posted: 09 Feb 2010, 07:58
by HeSitated
Log in through SSH and execute:
What does it say?
Re: mysql primer
Posted: 09 Feb 2010, 08:00
by asparak
MySQL is installed by default. Things like squeezecenter and Album use it
Re: mysql primer
Posted: 09 Feb 2010, 09:18
by Kiff
log in with "mysql -u root" (the root password is empty be default)
http://www.webdevelopersnotes.com/tutor ... abase.php3
Re: mysql primer
Posted: 09 Feb 2010, 18:18
by zander
HeSitated wrote:Log in through SSH and execute:
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#
Re: mysql primer
Posted: 10 Feb 2010, 02:42
by 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.
Re: mysql primer
Posted: 10 Feb 2010, 04:35
by HeSitated
This lists all running processes with the word mysql in it...
zander wrote:
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.
