[olug] Re: MySQL Question

[CM Miller]

Brian- 

Here is my.cnf file, I've installed from the RPM now,
not the tgz file to see what better luck I
have...please let me know what changes I need to make
to this file to make it work. 

[mysql]
datadir=/usr/local/MySQL/mysql-3.23.52-pc-linux-gnu-i686/data/
socket=/tmp/mysql.sock    #My mysql.sock is located
under /tmp, is 
that right?

[mysql.server] 
user=CMMiller
basedir=/usr/local/MySQL/mysql-3.23.52-pc-linux-gnu-i686/

[safe_mysqld]
err-log=/var/log/mysql.log  #I do not show this file
in /var/log nor 
do I show a mysql.log in the MySQL directory
pid-file=/var/run/mysqld/mysqld.pid #I also do not
show this under 
/var/run

[mysqld]
socket=/tmp/mysql.sock

[client]
socket=/tmp/mysql.sock



--- Brian Roberson <roberson at olug.org> wrote:
> 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
> >
> 
> _______________________________________________
> OLUG mailing list
> OLUG at olug.org
> http://lists.olug.org/mailman/listinfo/olug


=====
*****************************************
GAIM ID:  cmmiller1973
*****************************************

__________________________________________________
Do you Yahoo!?
New DSL Internet Access from SBC & Yahoo!
http://sbc.yahoo.com