Jump to content

Question of standard MySQL functions


_Dark_

Recommended Posts

Posted

How to get an associative array using the standard functions?

In MySQL, this

mysql_fetch_assoc, but it's not in new standard functions MTA. Can be an example?

Posted

Somehow my mysql login info ended up in that file, oops!

If you cant work with that MySQL, you can also use the MYSQL class in mta-paradise as an example, it is very good, stable and you can learn a lot from it.

Posted
Somehow my mysql login info ended up in that file, oops!

A bit off-topic, but important nonetheless:

You should never use the root account for your MTA server (or anything in general other than database administration). You should always create a MySQL user for your MTA server, and limit their permissions (i.e making it so they can't use 'DROP TABLE accounts' and modify other tables not related to the MTA sever). If you know for a fact you will only be using your database locally, limit your MTA server's MySQL account to localhost - that way, even if your MySQL credentials are leaked, remote users can not access your database.

Posted
Somehow my mysql login info ended up in that file, oops!

A bit off-topic, but important nonetheless:

You should never use the root account for your MTA server (or anything in general other than database administration). You should always create a MySQL user for your MTA server, and limit their permissions (i.e making it so they can't use 'DROP TABLE accounts' and modify other tables not related to the MTA sever). If you know for a fact you will only be using your database locally, limit your MTA server's MySQL account to localhost - that way, even if your MySQL credentials are leaked, remote users can not access your database.

lolol, like i dont know that, its just for local testing, any servers that i run have accounts limited to only updating, selecting and inserting.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...