Jump to content

Search the Community

Showing results for tags 'MySQL'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Forums

  • General Discussion
    • Website Management and Coding
    • Technology and the Internet
    • Philosophy, Politics, and Science
    • Art and Entertainment
    • Other Discussion
  • HelioHost
    • Questions
    • Customer Service
    • How You Can Help
  • HelioNet
    • News
    • Contact HelioNet

Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


AIM


MSN


Website URL


ICQ


Yahoo


Jabber


Skype


Location


Interests

  1. Hi I´m trying to connect a mysql database with PHP using: $con = mysqli_connect('localhost','some_user,'some_user_password','some_table_name'); and getting the following error: Fatal error: Call to undefined function mysqli_connect() in /home/...../public_html/..../some.php on line 501 The problem is that was OK a week ago. What am I doing wrong? Or, did something changed on PHP, Mysql? TIA Marcus
  2. Hi, it is possible to create MYSQL databases from a PHP script on Tommy? Thanks
  3. I have a mysql db with two separate users. But whenever I try to connect to it via mysql workbench or my application it shows the max_user_connections error. I checked the connections with 'show processlist' and it showed 2 new connections each time I fired the query so I assumed the two were used to query the connections. I also added the wildcard host '%' as allowed remote host since my application is a swing application and I don't know my teachers ip address. I am really running out of ideas here, if there is no other way to solve this problem I would appreciate you increasing my maximum connections cPanel Username: emanuels Main Domain: emanuels.heliohost.org Server: johnny Kind regards A desperate student trying to get his database working
  4. Hi again, I'm trying to connect to a database remotely via vb.net and have setup remote access and a new user for the database(one which I have not yet used to connect to the database) and I'm getting the error that the user has more active connections than the allowed max_user_connections. The weirder thing is than when i check the process list the named user cezihred_euput isn't even listed, just my cpanel username twice as the user.
  5. I am trying to set foreign keys on tables in mysql on johnny but they aren't working.Are the foreign keys disables for mysql on johnny ?
  6. hello, im new to website hosting sites and stuff... so my problem is that i want to connect a database to my website which i made it on my system using mysql all i want is my database to show up in phpmyadmin from where i can do the editing and stuff to my database that is present on my system. i dont want to import and export files. i need to be able to do changes to my database directly from phpmyadmin through my website and same changes must be applied to my database and i should be able to see it using mysql in my system. and the data i collect from the html file must directly go into the database of my system so that i can access it offline aswell. i know this is very stupid question to ask but it be very helpful for me if someone actually told me how to connect. can u please tel me what host name should i give instead of local host and database username and password in my php file.. thanks in advance.
  7. Hi eveyone! I am using the following code to connect to my mySQL database: <?php // Create connection$conn = mysqli_connect('localhost', 'database_user_name', 'database_password');// Check connectionif (!$conn) {die("Connection failed: " . mysqli_connect_error());} mysqli_select_db($conn,"database_name"); ?> I tried several variants of this, replacing parameters: mysqli_connect('tommy.heliohost.org', 'database_user_name', 'database_password'); mysqli_connect('localhost', 'database_name', 'database_password'); mysqli_connect('tommy.heliohost.org', 'database_name', 'database_password'); None of those seem to work. Could you please help me out figure out which host, username and password I should use to make this work. To note, my website is currently hosted on tommy.heliohost.org. Is this also true for mySQL database? In the next step I will be trying to connect remotely and it would be cool if you also let me know what the hostname for the external world looks like, and how do i log onto it. Thank you very much! Best, Milan
  8. i am getting the following error (XID ss47ay) Error while connecting to MySQL: (XID ny7xpq) Database Connect Error: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) Error while connecting to MySQL: (XID ny7xpq) Database Connect Error: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) at /usr/local/cpanel/Cpanel/Mysql.pm line 173.
  9. Hi guys, I'm new user of Heliohost who yesteday made MySQL database on Johnny server, which is needed for small university's project, this means I'm using remote connection [from SQLDeveloper actually]. Connection, making tables went well, but problems has begun when I tried to fill some small data into it. Almost every single time, when I try to look into table f.e. to see what columns I've got in there or just to check if insert query was made in the way I would like it to I receive an error message: After that I get connection reset. What I should to manage with thie case? Looking forward for your help!
  10. Hello, I'm having a problem with my remote connection to MySql.Error: MySqlException: Access denied for user 'purepast_root'@'201.17.240.159' (using password: YES)
  11. Hi, I have a MySQL server on jhonny and would like increase my mysql max remote connections. I am currently only able to make three connections at maximum. cPanel Username: kxk06010 Main Domain: autopartstore.heliohost.org Server: johnny
  12. Hello How can i set max user connections from 4 to 0 as you can see but i get error (Access denied) Cpanel username: dw Main Domain: dw.heliohost.org Server: johnny.heliohost.org E-mail: hak.ghosts@gmail.com
  13. How to increase mysql max user connections Hello i have an test program which used mysql connection string using remote mysql the program working successfully but when i give it to my friend while me opened the program or connect to the server using MySQLConnector it says Error to connect because user {name} already has more than 'max_user_connections' active connections. so i want to learn how to increase the size of it or how to fix it and i cannot use database users i have created so i using the default user it's the problem because that? if that true so how can i use the database users i have created because everytime i entered the password it says the password is wrong to connect to this database user!!
  14. Greetings! I am trying to create a simple application in java FOR EDUCATIONAL PURPOSE. In that, I want to create databases dynamically. eg.: when i register, i get a database. ONLY TRIAL BASIS, nothing more than that. I have tried that with remote access from my development machine to tommy.heliohost.org, but i am getting an error while creating database. ALL OTHER TASKS ARE WORKING FINE EXCEPT THIS ONE: create database. Error: Access denied for user '*******'@'59.95.116.27' to database '**************' *: my user and database names. Is it possible? Any suggestions? I again declare that it is ONLY for learning. Thanks.
  15. Hey, as per the latest update on the news channel, Stevie backups should be available soon. Awesome! Will MySQL databases be backed up? I'm not sure which engine they use. Also, will we be able to access the backups for a continuous period of time or short segregated spans? And, any estimate on around when we will be able to access the backups?
  16. Username=wikinet Server=Stevie Dear Heliohost Support I today downloaded the backup of my old Stevie account from heliohost.org/backup. However the MySQL backup inside the tar.gz archive is truncated as the size of file wikinet_qa.sql is just 2 KB instead of being around 6 to 8 MB. Please help me to get the MySQL file backup as I need it to update my website. Many Thanks
  17. Hi, A certain softaculous script does not support remote MySQL hosts, and does support only "localhost" as MySQL host. Do you implement a remote host or localhost? Server: Steive Thanks Ashraf
  18. Hi, I wanted to import a database (.sql) with phpMyAdmin but i've got this error : InnoDB is in read only mode. Please help me to fix this issue. Thanks.
  19. Dear admins, I am seeking explanation and little enlightment for current issues. Like other users, I am facing MySQL server downtime and concern over it. I am withnessing this as third time for 1 or 2 months. Is it problem for now or will the be a chance for continuity. Using Heliohost for setting up the site and will be using for next few more months but facing situation to moved out soon because of this issue. I really want to stick around here for the service and technical support from you guys. Hope to hear some explanation as I have requested. Noorul
  20. Hello, I have a problem with my MySQL database. MSG: The MySQL server is currently offline. Error while connecting to MySQL: Cpanel::DBI::Mysql connect('','root',...) failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) at /usr/local/cpanel/Cpanel/MysqlUtils/Connect.pm line 156 Error while connecting to MySQL: Cpanel::DBI::Mysql connect('','root',...) failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) at /usr/local/cpanel/Cpanel/MysqlUtils/Connect.pm line 156 ...caught Help me! Server Off line. Thank you.
  21. Good day, on this day I could not connect to mysql on stevie server. Error while connecting to MySQL: Cpanel::DBI::Mysql connect('','root',...) failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) at /usr/local/cpanel/Cpanel/MysqlUtils/Connect.pm line 156 Error while connecting to MySQL: Cpanel::DBI::Mysql connect('','root',...) failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) at /usr/local/cpanel/Cpanel/MysqlUtils/Connect.pm line 156 ...caught Good day, on this day I could not connect to mysql on stevie server.
  22. Where in the file manager should I put php files that I want to run externally with a url? After putting the file in the correct directory will I be able to run it with the following url? example.heliohost.org/file.php
  23. Username: bowo Server: stevie Hi helio admin, I have a problem with my wordpress database. When I open my wordpress site (bowo.heliohost.org) it shows: Error establishing a database connectionThe database name is bowo_wordpress. Checking database through cPanel shows: Error from MySQL query: DBD::mysql::db do failed: Unknown database 'bowo_wordpress'Failed to use bowo_wordpress: Unknown database 'bowo_wordpress' Same error message when I tried to repaired it. I hope it is still possible to recover it. Thanks.
  24. I've been trying to add an access host to my site's database, it says that "The host “%” was added to the access list." but it remains empty. Is this function disabled now?
  25. HI, I was unable to access phpmyadmin. Consequently changed my cpanel password. Was able to accesss to phpmyadmin however no databases are showing up in phpmyadmin. Here are the missing ones: 1. gujsingh_millennium1 2. gujsingh_rajgarh 3. gujsingh_unique please recreate / fix it ASAP. Thanks guj Ref: http://www.helionet.org/index/topic/22939-solved-empty-database/?hl=%2Bdatabases+%2Bshow&do=findComment&comment=113730
×
×
  • Create New...