[olug] Re: MySQL Question

[Brian Roberson]

If you want to use an rpm.... you NEED to remove all older mysql files, OR use 
the --force option to rpm to overwrite _ALL_ files



On Friday 08 November 2002 08:40 am, CM Miller 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