Re: advice

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: 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)
  • Re: Access 2002 FE with SQL Server 2k BE - Login failed for user A
    ... then linked to a table in DatabaseB on the SQL Server using an ODBC ... time I’m watching the SQL trace I have running to see if that login failure ... I’m prompted for the database login and ... absolutely nothing to do with DatabaseA and it’s Admin login. ...
    (microsoft.public.office.misc)
  • Re: advice
    ... the admin thing was just a test login, but couldn't get it to work. ... spotted a mysql newsgroup which I will post in... ... 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: PDO: Switch database user without reopening connection
    ... At the bare minimum there will be a login user who only has ... modifications to the database as well (editors get update permission, ... As database connections are expensive to ... a certain visitor in the Session, and use that value to start the right ...
    (comp.lang.php)