[olug] Re: MySQL Question

[CM Miller]

whoopppssss...

Meant to send this to Brian, but if anyone else can
help, feel free to answer...

thanks

-Chris 


--- CM Miller <cmmiller1973 at yahoo.com> wrote:
> 
> 
> 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
> _______________________________________________
> 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