Home > Archive > PHP SQL > December 2004 > MySQL
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| triple_h 2004-12-24, 3:56 pm |
| Which would be the best way to run MYSQL on a web server, for people to
create there own data base,username and pass ?
| |
| Norman Peelman 2004-12-25, 3:56 pm |
| "triple_h" <triple_h@bellsouth.net> wrote in message
news:sNYyd.23129$wZ1.20566@bignews3.bellsouth.net...
> Which would be the best way to run MYSQL on a web server, for people to
> create there own data base,username and pass ?
>
>
MySQL keeps a USER table of it;s own. So all you have to do (after
installation) is when want to let a new user use MySQL:
1) Put the users username and password into the MySQL USER table
2) Set all the proper permissions for this user in the MySQL USER table
(read, write, update, etc)
3) Tell them that in their scripts they must use
'mysql_connect(host,username,password)' to use MySQL
That is the basics... you should really do yourself a favor and get a book
on using PHP/MySQL or go to
http://dev.mysql.com/doc/ or
http://dev.mysql.com/doc/mysql/en/index.html
The latter is the online, english, searchable with user comments
documentation.
Norm
| |
| triple_h 2004-12-25, 3:56 pm |
| I bought a book called PHP and MySQL Web Development
"Norman Peelman" <npeelman@cfl.rr.com> wrote in message
news:nmdzd.175519$Oc.115558@tornado.tampabay.rr.com...
> "triple_h" <triple_h@bellsouth.net> wrote in message
> news:sNYyd.23129$wZ1.20566@bignews3.bellsouth.net...
>
> MySQL keeps a USER table of it;s own. So all you have to do (after
> installation) is when want to let a new user use MySQL:
>
> 1) Put the users username and password into the MySQL USER table
> 2) Set all the proper permissions for this user in the MySQL USER table
> (read, write, update, etc)
> 3) Tell them that in their scripts they must use
> 'mysql_connect(host,username,password)' to use MySQL
>
> That is the basics... you should really do yourself a favor and get a book
> on using PHP/MySQL or go to
> http://dev.mysql.com/doc/ or
> http://dev.mysql.com/doc/mysql/en/index.html
>
> The latter is the online, english, searchable with user comments
> documentation.
>
> Norm
>
>
| |
| Norman Peelman 2004-12-26, 3:56 am |
| That's the one I have... great book to get started with. And like I said,
you can learn alot from the mysql web site.
Norm
--
FREE Avatar hosting at www.easyavatar.com
"triple_h" <triple_h@bellsouth.net> wrote in message
news:Whhzd.9785$Xu3.8871@bignews4.bellsouth.net...
> I bought a book called PHP and MySQL Web Development
>
> "Norman Peelman" <npeelman@cfl.rr.com> wrote in message
> news:nmdzd.175519$Oc.115558@tornado.tampabay.rr.com...
to[color=darkred]
book[color=darkred]
>
>
|
|
|
|
|