Re: advice

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

Cheers, Ash


"gjb" <Kookookaachoo@xxxxxxxxxxx> wrote in message
news:4SZLf.26282$wl.20042@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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@xxxxxxxxxxx> wrote in
message news:6OZLf.3901$5M6.2416@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

"gjb" <Kookookaachoo@xxxxxxxxxxx> wrote in message
news:CkZLf.26271$wl.7873@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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_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









.

Relevant Pages

  • Re: Capture IP Address
    ... I have some MS Access front end databases linked to SQL Server 2000 ... logins for every user that requests access to the database and capture every ... The interesting part is that the Login Failed attempt ... any of our databases named 'Admin' especially to our Master. ...
    (microsoft.public.sqlserver.security)
  • Re: What is wrong in my source-code?
    ... This is my login code in PHP: ... Users on my locale server have to login to see my pages. ... username and password are stored in the database. ... MySQL is perfectly happy with performing more than one query in a single call. ...
    (comp.lang.php)
  • Re: advice
    ... the admin thing was just a test login, but couldn't get it to work. ... correct database selected, but it's the users I'm struggling with. ... I would say taht you probably don't want an admin being able to ...
    (comp.databases.ms-sqlserver)
  • Re: Needing a guide/tutorial please
    ... MySQL (for database driven mail user administration) ... Postfix Admin <- this is the reason for the need to have a mysql driven ...
    (freebsd-questions)
  • Re: User Permissions
    ... I hope that you have followed the necessary steps to secure your database. ... You don't just go into the security menu and start adding users/groups. ... You need to set a password for the Admin user to get the login back. ...
    (microsoft.public.access.security)