Just for Newbies
Subject: I have mysql woes too
Posted on: 11 September 1999 by Mark Metson
Post:I followed mysql turorial to create a database:
mysql> use mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> insert into
-> host(host,db,Select_priv,Insert_priv,Update_priv,
-> Delete_priv,Create_priv,Drop_priv)
-> values('localhost','mydb','Y', 'Y', 'Y', 'Y', 'Y', 'Y');
Query OK, 1 row affected (0.05 sec)
mysql> insert into
-> host(host,db,Select_priv,Insert_priv,Update_priv,
-> Delete_priv,Create_priv,Drop_priv)
-> values('24.222.15.2','mydb','Y', 'Y', 'Y', 'Y', 'Y', 'Y');
Query OK, 1 row affected (0.01 sec)
mysql> insert into
-> host(host,db,Select_priv,Insert_priv,Update_priv,
-> Delete_priv,Create_priv,Drop_priv)
-> values('24.222.15.%','mydb','Y', 'Y', 'Y', 'Y', 'Y', 'Y');
Query OK, 1 row affected (0.00 sec)
That told me at least that mysqld is working.
However, neither the mysqladm CGI package nor the mysqladmin CGI package
nor the Discussit! module had been able to get any info from the daemon
and doing the above has not helped to get Discussit! to use "mydb".
For some reason although the commandline mysql programs on the box seem
to work, none of the CGI systems do nor does Roxen. I wanted to use the CGI ones
to ceate the DB for Discussit! but had to resort to trying to figure out the commandline
mysql program and even then still no luck.
I do notice that mysql config file allows one to specify the port to connect to,
yet Discussit! has no option for specifying the port. mysqld is running on port
3066 I think? Whatever its default port is, anyway.
DIscussit! Also does not seem to allow specifying what manner of database to
use; is mysql correct or do I need msql or postgres maybe? I found that my
xwindows xform-based msql software doesnt seem to work with mysql but since
none of the actual mysql CGIs do either am thinking maybe it would if they did?
This whole mysql thing seems awful complexity to get into just to set up a Roxen
module! ;-) It would maybe help if the module had a way to set up the DB itself,
or docs showing explicitly how.
[ New Post ] [ Post Reply ] [ Previous Post ] [ Next Post ] [ Previous in Thread ] [ Next in Thread ] [ Forum Index ]
Follow Up:
