by lsd » Sun, 31 Dec 1899 09:00:00
by Grega Breme » Sun, 31 Dec 1899 09:00:00
Try comp.os.linux.misc or comp.os.linux.networking next time.
Cheers,
Grega
--
-----------------
Grega Bremec
Vrbnje 60
4240 Radovljica
Slovenija
+386 64 710 267
---------------------------
by Bob Hauc » Sun, 31 Dec 1899 09:00:00
But to answer your question, yes, MySQL is a relational database.
--
-| Bob Hauck
-| Wasatch Communications Group
-| http://www.wasatch.com/~bobh
by mlw » Sun, 31 Dec 1899 09:00:00
> 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
--
Mohawk Software
Windows 95, Windows NT, UNIX, Linux. Applications, drivers, support.
Visit http://www.mohawksoft.com
by Matthias Wark » Sun, 31 Dec 1899 09:00:00
> > 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.
mawa
--
"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
below:
<html>
<body>
<?php
$myvar = "Hello Adam";
echo $myvar;
?>
</body>
</html>
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):
<html>
<body>
<?php
$db = mysql_connect("localhost", "root");
mysql_select_db("mydb",$db);
$result = mysql_query("SELECT * FROM employees",$db);
printf("First Name: %s<br>\n", mysql_result($result,0,"first"));
?>
</body>
</html>
When I open my browser to http://target_Svr/test2.php3, I get the
following
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
First Name:
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.
2. How to remotely execute commands as root
3. start mysql database as mysql instead of root
5. Can't connect to local MySQL server through socket '/tmp/mysql.sock'
6. diag switch waiting for network package
7. mysql with c, cant find declaration of mysql-functions...
8. gcc binary for solaris 2.5 x86?
9. Can't connect to local MySQL server through socket '/tmp/mysql.sock'
10. mySQL: where is mysql-server.sh?
12. Only user "root" and "mysql" can connect to mysql?
13. PHP/MySQL "mysql.sock" not found ???