Posted by mistral on 10/31/06 15:34

"Jerry Stuckle wrote:
"
> mistral wrote:
> > "Jerry Stuckle wrote:
> > "

> >>mistral wrote:
> >>
> >>>"Jerry Stuckle wrote:
> >>>"


> >>>>mistral wrote:
> >>>>
> >>>>
> >>>>>Need php script to create mySQL database programmatically; since
> >>>>>hosting configuration may not allow create database from script, script
> >>>>>also need eliminate/rewrite all restrictions in appropriate places in
> >>>>>that hosting.
> >>>>>
> >>>>
> >>>>You can make a script to create a database. But you can't make a script
> >>>>which will hack the host's security settings.
> >>>>
> >>>>--
> >>>>==================
> >>>>Remove the "x" from my email address
> >>>>Jerry Stuckle
> >>>>JDS Computer Training Corp.
> >>>>jstucklex@attglobal.net
> >>>>==================
> >>>
> >>>======================================
> >>>
> >>>Need working code to create database programmatically via PHP.
> >>>
> >>>M.
> >>>
> >>
> >>Not a problem. Here are some links to get you started:
> >>
> >>For the SQL you need:
> >>
> >>http://dev.mysql.com/doc/refman/5.1/en/create-database.html
> >>http://dev.mysql.com/doc/refman/5.1/en/create-table.html
> >>
> >>And optionally:
> >>
> >>http://dev.mysql.com/doc/refman/5.1/en/create-index.html
> >>
> >>
> >> From the PHP end, check out:
> >>
> >>http://www.php.net/manual/en/function.mysql-connect.php
> >>http://www.php.net/manual/en/function.mysql-create-db.php
> >>http://www.php.net/manual/en/function.mysql-select-db.php
> >>http://www.php.net/manual/en/function.mysql-query.php
> >>http://www.php.net/manual/en/function.mysql-close.php
> >>
> >>And for error processing, you'll want:
> >>
> >>http://www.php.net/manual/en/function.mysql-error.php
> >>
> >>This should get you started.
> >>
> >>--
> >>==================
> >>Remove the "x" from my email address
> >>Jerry Stuckle
> >>JDS Computer Training Corp.
> >>jstucklex@attglobal.net
> >>==================
> >
> >
> >
> >
> > Code from php.net does not work..
> >
> > <?php
> > $link = mysql_connect('localhost', 'mysql_user', 'mysql_password');
> > if (!$link) {
> > die('Could not connect: ' . mysql_error());
> > }
>
> > $sql = 'CREATE DATABASE my_db';
> > if (mysql_query($sql, $link)) {
> > echo "Database my_db created successfully\n";
> > } else {
> > echo 'Error creating database: ' . mysql_error() . "\n";
> > }
> > ?>


> > Warning: mysql_connect() [function.mysql-connect]: Can't connect to
> > local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) in
> > /web/www/domain/users/u/username/createdb.php on line 2
> > Could not connect: Can't connect to local MySQL server through socket
> > '/var/run/mysqld/mysqld.sock' (2)

> > Ugly, very ugly..

> > m.


> Are you running this on the server with MySQL installed? If so, it
> looks like MySQL isn't running or the admin has it set up different from
> the defaults.

> Either way the only one who can tell you more is your hosting company.

> --
> ==================
> Remove the "x" from my email address
> Jerry Stuckle
> JDS Computer Training Corp.
> jstucklex@attglobal.net
> ==================

yes, installed. Just run phpinfo.php, it show the following MySQL
related info :


mysql

MySQL Support: enabled
Active Persistent Links: 0
Active Links: 0
Client API version: 5.0.24a
MYSQL_MODULE_TYPE: external
MYSQL_SOCKET: /var/run/mysqld/mysqld.sock
MYSQL_INCLUDE: -I/usr/include/mysql
MYSQL_LIBS: -L/usr/lib -lmysqlclient

Directive Local Value Master Value
mysql.allow_persistent: On On
mysql.connect_timeout: 60 60
mysql.default_host: no value no value
mysql.default_password: no value no value
mysql.default_port: no value no value
mysql.default_socket: no value no value
mysql.default_user: no value no value
mysql.max_links: Unlimited Unlimited
mysql.max_persistent: Unlimited Unlimited
mysql.trace_mode: Off Off


m.

[Back to original message]