all groups > sql server (alternate) > february 2006 >
You're in the

sql server (alternate)

group:

advice


advice gjb
2/25/2006 1:54:42 PM
sql server (alternate):
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_test: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


Re: advice Greg D. Moore (Strider)
2/25/2006 2:26:10 PM

[quoted text, click to view]


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.


[quoted text, click to view]

Re: advice Erland Sommarskog
2/25/2006 2:26:52 PM
gjb (Kookookaachoo@hotmail.com) writes:
[quoted text, click to view]

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/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
Re: advice gjb
2/25/2006 2:30:24 PM
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.

[quoted text, click to view]

Re: advice NO[at]SPAM sh
2/27/2006 2:37:01 PM
I'd learn about the differences between the two first! Its useful to know
the advantages and disadvantages of both.

Cheers, Ash


[quoted text, click to view]

AddThis Social Bookmark Button