Microsoft SQL Server forum

Author

advice

gjb

2006-02-25, 9:45 am

Hi,

Apologies if this sounds dumb but I'm very new to this.

I'm just trying to create a simple login page (
http://aarkenuk.co.uk/barnesg/login.php) In my MySQL databases I have the
correct database selected, but it's the users I'm struggling with. You get
like a front end with my hosting space (CpanelX) and in there I've created
user "admin" password "admin" but I cannot seem to login.

This is what I see in the front end..

Users in test
barnes_admin (Privileges: ALL PRIVILEGES)

Connection Strings
Perl $dbh =
DBI->connect(" DBI:mysql:barnes_tes
t:localhost","barnes_admin","<PASSWORD
HERE>");
PHP $dbh=mysql_connect ("localhost", "barnes_admin", "<PASSWORD
HERE>") or die ('I cannot connect to the database because: ' .
mysql_error());
mysql_select_db ("barnes_test");

Is there anything more I need to do? Do you login with barnes_admin or just
admin? (I've tried both) and why does it created barnes_admin and not just
admin? Also what are the connection strings for? do I need to do anything
with these?

Thanks very much in advance for any advice..

Gary

Greg D. Moore $Strider$

2006-02-25, 9:45 am

"gjb" < Kookookaachoo@hotmai
l.com> wrote in message
news:CkZLf.26271$wl.7873@text.news.blueyonder.co.uk...
> Hi,
>
> Apologies if this sounds dumb but I'm very new to this.
>
> I'm just trying to create a simple login page (
> http://aarkenuk.co.uk/barnesg/login.php) In my MySQL databases I have the
> correct database selected, but it's the users I'm struggling with. You get
> like a front end with my hosting space (CpanelX) and in there I've created
> user "admin" password "admin" but I cannot seem to login.
>

This is a Microsoft SQL Server group, not MySQL group so you're probably not
going to find as much help here as you'd ilke.

However, I would say taht you probably don't want an admin being able to
access your database from a webpage simply for security reasons.

> This is what I see in the front end..
>
> Users in test
> barnes_admin (Privileges: ALL PRIVILEGES)
>
> Connection Strings
> Perl $dbh =
> DBI->connect(" DBI:mysql:barnes_tes
t:localhost","barnes_admin","<PASSWORD
> HERE>");
> PHP $dbh=mysql_connect ("localhost", "barnes_admin", "<PASSWORD
> HERE>") or die ('I cannot connect to the database because: ' .
> mysql_error());
> mysql_select_db ("barnes_test");
>
>
>
> Is there anything more I need to do? Do you login with barnes_admin or
just
> admin? (I've tried both) and why does it created barnes_admin and not just
> admin? Also what are the connection strings for? do I need to do anything
> with these?
>
> Thanks very much in advance for any advice..
>
> Gary
>
>
>

Erland Sommarskog

2006-02-25, 9:45 am

gjb (Kookookaachoo@hotma
il.com) writes:
> Apologies if this sounds dumb but I'm very new to this.
>
> I'm just trying to create a simple login page (
> http://aarkenuk.co.uk/barnesg/login.php) In my MySQL databases I have the
> correct database selected, but it's the users I'm struggling with. You get
> like a front end with my hosting space (CpanelX) and in there I've created
> user "admin" password "admin" but I cannot seem to login.

I don't know whether the best place for this question is a newsgroup
about PHP or MySQL, but thius group is about Microsoft SQL Server, and your
chances to get help are not fantastic.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

gjb

2006-02-25, 9:45 am

Ah, again apologies for my ignorance, I wasn't aware there was a
differance...!

the admin thing was just a test login, but couldn't get it to work. I've
spotted a mysql newsgroup which I will post in...

Many thanks for the help.

"Greg D. Moore (Strider)" < mooregr_deleteth1s@g
reenms.com> wrote in message
news:6OZLf.3901$5M6.2416@newsread2.news.atl.earthlink.net...
>
> "gjb" < Kookookaachoo@hotmai
l.com> wrote in message
> news:CkZLf.26271$wl.7873@text.news.blueyonder.co.uk...
>
>
> This is a Microsoft SQL Server group, not MySQL group so you're probably
> not
> going to find as much help here as you'd ilke.
>
>
> However, I would say taht you probably don't want an admin being able to
> access your database from a webpage simply for security reasons.
>
>
> just
>
>

@sh

2006-02-28, 8:29 pm

I'd learn about the differences between the two first! Its useful to know
the advantages and disadvantages of both.

Cheers, Ash

"gjb" < Kookookaachoo@hotmai
l.com> wrote in message
news:4SZLf.26282$wl.20042@text.news.blueyonder.co.uk...
> Ah, again apologies for my ignorance, I wasn't aware there was a
> differance...!
>
> the admin thing was just a test login, but couldn't get it to work. I've
> spotted a mysql newsgroup which I will post in...
>
> Many thanks for the help.
>
> "Greg D. Moore (Strider)" < mooregr_deleteth1s@g
reenms.com> wrote in
> message news:6OZLf.3901$5M6.2416@newsread2.news.atl.earthlink.net...
>
>

Sponsored Links