[olug] Re: MySQL Question

[Brian Roberson]

ok, the easiest way I know to resolve your issue.....
start all over....


cd /some/where/with/60+Mb/
# get the tarball wget / lynx / point-n-click .. whatever
wget http://mysql.he.net/Downloads/MySQL-3.23/mysql-3.23.53.tar.gz
# untar and move into the src dir
tar xvzf mysql-3.23.53.tar.gz
cd mysql-3.23.53
# add the user you want to run mysqld as ( good security practice ) ... may
already exist
useradd -d /usr/local/mysql mysql > /dev/null 2>&1
# there are a plethora of config options, here are some basic needed ones
./configure --prefix=/usr/local/mysql --with-mysqld-user=mysql
# make it!
make
# install it ( need root access )
su root
make install
# install the initial user databases
/usr/local/mysql/bin/mysql_install_db
# make sure the mysql user owns it all
chown -R mysql /usr/local/mysql/
# put the startup script into init to make it always run
echo "sql:35:respawn:/usr/local/mysql/bin/safe_mysqld" >> /etc/inittab
# re-read /etc/inittab
init q
## hopefully it is running.... " ps -ef | grep sql" should give back a few
mysqld process's
## Pick a mysql "super user" password.. e.g. dont use "MYSQL_ROOT_PASSWD"
;-)
/usr/local/mysql/bin/mysqladmin password MYSQL_ROOT_PASSWD
# create a db for you to use
echo "create database foo" |
/usr/local/mysql/bin/mysql -uroot -pROOT_PASSWORD
# grant someone full permissions to the db you just created -- long line,
notice the \ for continuation here!
echo "grant all on foo.* to userid@'localhost' identified by 'some_password'
with grant option" |  \
/usr/local/mysql/bin/mysql -uroot -pROOT_PASSWORD


all done!

/usr/local/mysql/bin/mysql -uuserid -psome_password foo
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3301 to server version: 3.23.52-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>










----- Original Message -----
From: "CM Miller" <cmmiller1973 at yahoo.com>
To: "Brian Roberson" <roberson at olug.org>
Sent: Wednesday, November 06, 2002 2:41 PM
Subject: MySQL Question


>
>
> Brian-
>
> Could u possibly answer a question for me about MySQL?
>
> When I issue the command mysql as CMMiller, I get the
> following:
>
> mysql: unrecognized option
> '--datadir=/usr/local/MySQL/mysql-3.23.52-pc-linux-gnu-i686/data/
>
> This is coming from the my.cnf, but I'm not sure why
> it is doing this?
>
> I have MySQL under /usr/local/MySQL and installed as a
> tar file.
>
> thanks
>
> -Chris
>
>
>
>
> =====
> *****************************************
> GAIM ID:  cmmiller1973
> *****************************************
>
> __________________________________________________
> Do you Yahoo!?
> New DSL Internet Access from SBC & Yahoo!
> http://sbc.yahoo.com
>