473,383 Members | 1,925 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,383 software developers and data experts.

php script to create mySQL database programmatically

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.

Oct 31 '06 #1
14 6060
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
Oct 31 '06 #2

"Erwin Moller писал(а):
"
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
------------

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?

Oct 31 '06 #3
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.
js*******@attglobal.net
==================
Oct 31 '06 #4

"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.
js*******@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.

Oct 31 '06 #5
mistral wrote:
"Erwin Moller писал(а):
"
>>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

------------

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.
js*******@attglobal.net
==================
Oct 31 '06 #6
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.
js*******@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.
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.
js*******@attglobal.net
==================
Oct 31 '06 #7

"Jerry Stuckle писал(а):
"
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.
js*******@attglobal.net
==================
======================================

Need working code to create database programmatically via PHP.

M.

Oct 31 '06 #8
mistral wrote:
"Jerry Stuckle писал(а):
"
>>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.
js*******@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/...-database.html
http://dev.mysql.com/doc/refman/5.1/...ate-table.html

And optionally:

http://dev.mysql.com/doc/refman/5.1/...ate-index.html
From the PHP end, check out:

http://www.php.net/manual/en/function.mysql-connect.php
http://www.php.net/manual/en/functio...-create-db.php
http://www.php.net/manual/en/functio...-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.
js*******@attglobal.net
==================
Oct 31 '06 #9
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*.
Oct 31 '06 #10

"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.
js*******@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/...-database.html
http://dev.mysql.com/doc/refman/5.1/...ate-table.html

And optionally:

http://dev.mysql.com/doc/refman/5.1/...ate-index.html
From the PHP end, check out:

http://www.php.net/manual/en/function.mysql-connect.php
http://www.php.net/manual/en/functio...-create-db.php
http://www.php.net/manual/en/functio...-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.
js*******@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.

Oct 31 '06 #11
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.
js*******@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/...-database.html
http://dev.mysql.com/doc/refman/5.1/...ate-table.html

And optionally:

http://dev.mysql.com/doc/refman/5.1/...ate-index.html
From the PHP end, check out:

http://www.php.net/manual/en/function.mysql-connect.php
http://www.php.net/manual/en/functio...-create-db.php
http://www.php.net/manual/en/functio...-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.
js*******@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.
js*******@attglobal.net
==================
Oct 31 '06 #12
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

Oct 31 '06 #13
"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.
js*******@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/...-database.html
http://dev.mysql.com/doc/refman/5.1/...ate-table.html

And optionally:

http://dev.mysql.com/doc/refman/5.1/...ate-index.html
From the PHP end, check out:

http://www.php.net/manual/en/function.mysql-connect.php
http://www.php.net/manual/en/functio...-create-db.php
http://www.php.net/manual/en/functio...-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.
js*******@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.
js*******@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.

Oct 31 '06 #14
mistral wrote:
"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.
>>js*******@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/...-database.html
http://dev.mysql.com/doc/refman/5.1/...ate-table.html

And optionally:

http://dev.mysql.com/doc/refman/5.1/...ate-index.html
From the PHP end, check out:

http://www.php.net/manual/en/function.mysql-connect.php
http://www.php.net/manual/en/functio...-create-db.php
http://www.php.net/manual/en/functio...-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.
js*******@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.
js*******@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.
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.
js*******@attglobal.net
==================
Oct 31 '06 #15

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: sunlight_sg | last post by:
Hello, i am using ADOX + VB .NET to create a Access Database programmatically. I plan to set some properties of the column such primary key. The code is as follows: Dim cat As ADOX.Catalog...
2
by: drah | last post by:
Hello not exactly sure if it is a php script problem or a database/table issue i apologize if i'mposting in wrong category. I was asked to put a login script on a site for someone and i made the...
15
by: harvey | last post by:
How do I make PHP create a database for mysql please? I can see how to make tables and I have read all the documents I can find but I don't understand how to make the database itself. All...
10
by: AAaron123 | last post by:
I want to create a database with one table on the host. I can't user SQL Server Management Studio to do it so I guess I have to do it programmatically. I have in mind that in the session start...
1
by: Tatyasaheb Patil | last post by:
Dim file As FileInfo = New FileInfo(Path.GetFullPath("TextFile1.txt")) Dim backupScript As String = file.OpenText.ReadToEnd() Dim strCommand As String = backupScript ...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.