| Author |
php script to create mySQL database programmatically
|
|
| mistral 2006-10-31, 7:57 am |
| 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.
| |
| Erwin Moller 2006-10-31, 7:57 am |
| 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.
So you want a script that bypasses the securitysettings of your
hostingcompany?
Erwin
| |
| mistral 2006-10-31, 7:57 am |
|
"Erwin Moller =D0=BF=D0=B8=D1=81=D0=B0=D0=BB(=D0=B0):
"
> mistral wrote:
>
>
> So you want a script that bypasses the securitysettings of your
> hostingcompany?
>
> Erwin
------------
script must reconfigure/rewrite only settings that's responsible for
blocking of creating mySQL database programmatically, i.e. normal way.
Elementary. Is this clear enough?
| |
| Jerry Stuckle 2006-10-31, 7:57 am |
| 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
==================
| |
| mistral 2006-10-31, 7:57 am |
|
"Jerry Stuckle wrote:
"
> mistral wrote:
[color=darkred]
> 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
> ==================
Any workaround how to solve this programmatically? There is such
scripts, and yes, it possible, just can no find url i saw it.
| |
| Jerry Stuckle 2006-10-31, 7:57 am |
| mistral wrote:
> "Erwin Moller писал(а):
> "
>
>
> ------------
>
> script must reconfigure/rewrite only settings that's responsible for
> blocking of creating mySQL database programmatically, i.e. normal way.
> Elementary. Is this clear enough?
>
Yes. You want to hack your free host's security settings.
And if it could do that, there wouldn't be much sense to even having
security settings, would there?
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================
| |
| Jerry Stuckle 2006-10-31, 7:57 am |
| mistral wrote:
> "Jerry Stuckle wrote:
> "
>
>
>
>
>
>
>
>
> Any workaround how to solve this programmatically? There is such
> scripts, and yes, it possible, just can no find url i saw it.
>
You probably can't find it because it doesn't exist. Security is there
for a reason.
Locking your door doesn't do any good if you hand keys to everyone.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================
| |
| mistral 2006-10-31, 7:57 am |
|
"Jerry Stuckle =D0=BF=D0=B8=D1=81=D0=B0=D0=BB(=D0=B0):
"
> mistral wrote:
>
> You can make a script to create a database. But you can't make a script
> which will hack the host's security settings.
>
> --
> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
3D=3D=3D=3D=3D
> Remove the "x" from my email address
> Jerry Stuckle
> JDS Computer Training Corp.
> jstucklex@attglobal.net
> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
3D=3D=3D=3D=3D
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
Need working code to create database programmatically via PHP.
M=2E
| |
|
|
| Pedro Graca 2006-10-31, 7:57 am |
| 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.
LOL
Thank you.
--
I (almost) never check the dodgeit address.
If you *really* need to mail me, use the address in the Reply-To
header with a message in *plain* *text* *without* *attachments*.
| |
|
|
| Jerry Stuckle 2006-10-31, 7:57 am |
| mistral wrote:
> "Jerry Stuckle wrote:
> "
>
>
>
>
>
>
>
> 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
==================
| |
| Good Time Tribe 2006-10-31, 7:57 am |
| > 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.- Hide quoted text
That's actually a very helpful and friendly error message. It first
tells you why it failed. Then it tells you which machine is responsible
for the failure. Even further, it tells you what it expects that
machine to be responsible for. It tells you the full path to the
script. It also tells you the script's name and the line number of the
problem statemetns.
ppmd
| |
| mistral 2006-10-31, 6:58 pm |
| "Jerry Stuckle wrote:
"
> mistral wrote:
[color=darkred]
[color=darkred]
>
[color=darkred]
[color=darkred]
[color=darkred]
[color=darkred]
> 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.
| |
| Jerry Stuckle 2006-10-31, 6:58 pm |
| mistral wrote:
> "Jerry Stuckle wrote:
> "
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> 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.
>
This shows you what PHP thinks is installed. It may or may not match
the real installation, and even if it does match it doesn't mean MySQL
is currently running.
If MySQL support were not enabled, you would have gotten an "unknown
function" error message. But just because it's enabled doesn't mean it
works.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================
|
|
|
|