MPGHThe Dark Arts
RegisterLog in

Getting confused with MySQL

Posts 1–7 of 7 · Page 1 of 1
Getting confused with MySQL
Hello folks,

I'm currently trying *grr* to code a Login System with MySQL.
A friend of mine is helping me with his own Domain - means he got his own MySQL Server (PhPmyAdmin or something).
I used alot of Tutorials and everything works fine out of Connecting to the Database.
We can also create Tables/Databases and everything in it but we can't get remote access (using my Login program).

Always the same error:



We aren't that good with MySQL .. don't be that mad at ur stupidity :S.

---------------------------
MySQL Login
---------------------------
No connection to Database : Unable to connect to any of the specified MySQL hosts.
---------------------------
OK
---------------------------
Can someone help us getting that done?
#1 ·
Quote Originally Posted by D3t0N4t3 View Post
Hello folks,

I'm currently trying *grr* to code a Login System with MySQL.
A friend of mine is helping me with his own Domain - means he got his own MySQL Server (PhPmyAdmin or something).
I used alot of Tutorials and everything works fine out of Connecting to the Database.
We can also create Tables/Databases and everything in it but we can't get remote access (using my Login program).

Always the same error:



We aren't that good with MySQL .. don't be that mad at ur stupidity :S.



Can someone help us getting that done?
Post your code (block out the SQL authentication info) and I'll see what I can do.
#2 ·
Whats the connection string, indeed? (Exclude pass and user obv)
#3 ·
Here's a snippet:

Code:
Dim msql As MySqlConnection
msql = New MySqlConnection

msql.ConnectionString = "server=mysql.oursitename.de;" _
                                                 & "user ID=username;" _ 
                                                 & "password=ourpassword;" _
                                                 & "database=67610_0" 'Thats database name
#4 ·
I know you want to use mysql but there are different ways of logging in. More secure ways i mind you. But that's just my say.
#5 ·
Does your server allow for Remote MySQL connections? Most don't these days. Even if they do, chances are you'll have to add a whitelist of who can remotely connect in your server config (can usually be done though a cPanel setup).

Really, though, you shouldn't remotely connect to your database at all. Learn some basic PHP (there are many tuts on this forum) and create a login page on the server, then use HttpWebRequests to send data to the page for processing and deal with the pages return. This way you don't need to ever store your sensitive database details in a distributed application (which can be easily reversed).
#6 ·
We just take a look around.. using phpsupport and we got to know: We can't access remotely to the Server..
#7 ·
Posts 1–7 of 7 · Page 1 of 1

Post a Reply

Similar Threads

WarRock - International HacksHow To Get Hacks With Cheat Engine 5.3?naomelembro14naomelembro14 1 WarRock - International Hacksget veihcles with a uce..COcool4345 2 WarRock - International HacksGet TM with UCE Working+Addresses+My CT+Trainer HERE!!POpoisoner 59 Trade Accounts/Keys/Itemscan i get caugth with elite switchCLclucking bell chiken man 3 WarRock - International Hacksacc get fast with sq's lvl 51brownsfan91 12

Tags for this Thread

None

Talk with us