Try comp.os.linux.misc or comp.os.linux.networking next time.
+386 64 710 267
But to answer your question, yes, MySQL is a relational database.
-| Bob Hauck
-| Wasatch Communications Group
> Hi all
> I wanna use PHP+MySql to design an interactivity homepage in linux,
> but now i have a question about mysql.
> Does mysql is a relational database software? I had readed some manual of
> mysql,but i coundn't see any more about this question.
Windows 95, Windows NT, UNIX, Linux. Applications, drivers, support.
> > Hi all
> > I wanna use PHP+MySql to design an interactivity homepage in linux,
> > but now i have a question about mysql.
> > Does mysql is a relational database software? I had readed some manual of
> > mysql,but i coundn't see any more about this question.
> > thanks!
> > roger
> I don't know how to treat this question. mysql is a SQL database. SQL is
> inherently relational.
It doesn't check for either.
"The 6 remaining corporations [world-wide] have shown great interest
in merging with each other [...] Clearly, the stage is being set for
the creation of UniCorp, a $92 trillion corporation that produces
every product on earth, from canned yams [...] to poison gas."
I have a fresh installation of OpenBSD 3.2. I have not made any
alterations to the base installation. I enabled Apache via rc.conf
and tested (I also enabled server-status & server-info in httpd.conf).
I installed PHP4 from the packages tree at 3.2/Packages. I configured
according to the instructions at webmonkey and tested with phpinfo().
I integrated with Apache and tested with the sample php3 script shown
$myvar = "Hello Adam";
which worked fine. (Returned "Hello Adam")
I then installed mysql from the package currently in 3.2/Packages with
its supporting packages (p5-DBD-1.30, mysql-client-3.23.54,
p5-DBD-Mssql-Mysql-1.22.19, libiconv-1.8, gettext-0.10.40 and
recode-3.6). I enabled MySQL to start at reboot using the
instructions at http://www.hostbaby.com/misc/mysql-openbsd.html.
After a reboot, mysql starts on port 3306 w/a PID of 8643. I set the
password, created a test database and verified the functionality of
the base databases.
I added the php4-mysql-4.2.3 package to enable integration with MySql
and verified that phpinfo() returns MySQL integration successfully,
which it does.
I prepared the following script in /var/www/htdocs (named test2.php3):
$db = mysql_connect("localhost", "root");
$result = mysql_query("SELECT * FROM employees",$db);
printf("First Name: %s<br>\n", mysql_result($result,0,"first"));
When I open my browser to http://target_Svr/test2.php3, I get the
Warning: Can't connect to local MySQL server through socket
'/var/run/mysql/mysql.sock' (2) in /htdocs/test2.php3 on line 7
Warning: MySQL Connection Failed: Can't connect to local MySQL server
through socket '/var/run/mysql/mysql.sock' (2) in /htdocs/test2.php3
on line 7
Warning: mysql_select_db(): supplied argument is not a valid
MySQL-Link resource in /htdocs/test2.php3 on line 9
Warning: mysql_query(): supplied argument is not a valid MySQL-Link
resource in /htdocs/test2.php3 on line 11
Warning: mysql_result(): supplied argument is not a valid MySQL result
resource in /htdocs/test2.php3 on line 13
So, I rolled over to /var/run/mysql and noticed that mysql.sock did
exist with filesize 0.
I have been searching and working on this for over a week, any help
would be greatly appreciated. Top it off, its for a non-profit org
that I decided to help out.. so its a good cause.