Jump to content

mabaomsi

Members
 View Profile  See their activity

  • Posts

    29

  • Joined

  • Last visited

 Content Type 

Posts posted by mabaomsi

    Handle Max_User_Connection?

    in Questions

    Posted

    Yeah, my code seem like perfectly this. And from this Open/query/Close statement have i really a lot. But all connection with one maba_user. So and this is the error query, the account maba_user dont allow to have more connections from another computers with another IP-s. I think that is the problem.

    Handle Max_User_Connection?

    in Questions

    Posted

    Huh,so i need to close all the connection all the time? Or what? 😆😆 But i maked so my script before the error comes, i had 10-20 different connections (but, with the same, admin account, and database), that i forever closed(/conn.). So the essence is, that i can't have more active connections for my database FROM DIFFERENT IP addresses? (Sorry, but dont really understand, how i need to change my scripts...)

    Handle Max_User_Connection?

    in Questions

    Posted

    Aham, so can I open endless connections? But i dont thik so. When I used ONLY the app, the error didn`t happend, BUT when we (I and my friends, for example) open a "table" / connection in the same time, the error comes... :( So I cant have more than 2 connections in the same time, with my ONLY, one Cpanel (MySQL accesed) account, for ex. a (primary) "admin" account.

    Handle Max_User_Connection?

    in Questions

    Posted

    Hi, no, i think no. I open one connection again, when a new action is coming. Like: new command, reader... ("Mysqlconn.open") So, i have more win. forms, in there i open another connnevtions, and when i use a sqlreader, the system saids you have soon opened a reader, you need one another connection to open a new again.

    Handle Max_User_Connection?

    in Questions

    Posted · Edited by mabaomsi

    Hi, i'm Balázs form Hungary, and i have a question for YOU ALL! :D

     

    I have a application with a HeliHost MySQL ONLINE database. I created a table in my database for users (username, pass, join date etc...), that can register for my program (in my program). After register, the user become a new line with all the data, which there has entered under the registration (username, pass, join date etc...) in my user database. The users can login in to my program, using this "user".

    The user enter there username and pass, and if this datas are correct, "READING data from user table", than the user can sucess login. So, the login was sucessfully, the user entered my program. And now it's coming the problem. This program is for it, to have datas (veichles, objects, addons, and for all donwload links etc...) about a simulator game (OMSI 2), and to help the users, finding fastest a component form this simulator game, that he/she wants. So i have more tables, in my ONLINE database.

     

    BUT, i use all the time one, my account (admin) to handle, manage, read etc... the database.

    When MORE (!!!) users, IN THE SAME TIME want to recive, change datas for example: login, account making, searching/looking for component in a table, coming my problem: ..."user already has more than 'max_user_connections' active connections!"

     

    So, the problem can be, that i make all the requests with my ONLY one MySQL account: admin? I need to make users in the Cpanel, when a user register in my program, i need to make all the time a new user in my Cpanel too? And when yes, HOW? It is possible to acces Cpnael with vb.net code, form source, like the MySQL databases?

     

    Thanks, and a good afternoon for all!

    Balázs Lengyel

     

     

    Sorry for my REALLY bad english! :blink:

    How To Connect With Command Line?

    in Customer Service

    Posted

    Hi! But why?

    I really need it, i have / maked an WinForm applikation, who users can see the components from a simulation game (OMSI2), and the value 1 for max_conn. is nothing, min 10-30 poeople will used my app (i hope) in the same time from one/this database. And this wanna bee really shit, when the another 9-29 users cant connect, becuse one is now seen the database... You understand me? I really need to change it :(

    I my app, will all connections closed, when the command is runned sucesfully (f.e: SELECT * FROM blabla WHERE blabblabla = blabblabla)

    Can you help me, can we solved my problem?

     

    Thanks all!

    How To Connect With Command Line?

    in Customer Service

    Posted · Edited by mabaomsi

    Hi!

    I have a big problem. I want to change the max_user_connection variable on my Mysql server, but soon with the connection i have problem.

    I use MySQL Command Line 5.7 to change this value. With this codes:

    mysql> -h mabaomsi.heliohost.org -u 'my user name' -p 'my password' maba_jpo

THEN WITH THIS FORM:

mysql> -u 'my user name' -p 'my password' -h mabaomsi.heliohost.org maba_jpo

    But the Command Line have a syntax problem with this codes:

    ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near
'-u 'my user name' -p 'my password' -h mabaomsi.heliohost.org maba_jpo' at line 1

    Can someone help me?

    Thanks!

    My "website" Not Responding

    in Customer Service

    Posted

    Thanks for your answer.

    The site working now for me. I see now whats going on. The No1. server is Thommy, users need donate to use Thommy.

    I really like our service and hosting!

     

    I will see, how many uptime i need, and then Tommy is coming to me! :D Thnaks for all!

×
×
  • Create New...