Search the Community
Showing results for tags 'sql'.
-
Hi. I'm trying to figure out how functions and procedures works into MariaDB. And i creared a sinple function: BEGIN declare ans TEXT; select answer into ans from text_answers ORDER by rand() limit 1; RETURN ans; END and wanted to call this function by: SELECT * from dbo.random_text_answer but i've got a error of loss privileges... i wanted to try to check "Adjust privileges" in edit window, but this checkbox is unactive.. What should I do in this case?
-
Dear sir/madam, Recently, I have created a database with my Tommy account and wanted to connect it with my Lily ASP.NET website. I have managed to receive the data from the SQL database when I open the website locally but when I publish the website to the server and try to open the page with the SQL database records, I get an error (see picture). Could somebody help me to resolve this error? Thank you in advance. Yours faithfully, Robin (nickname: novafox)
-
Hello! Could somebody please help me enable remote access to my MySQL database? Is this done for all MySQL databases? Otherwise, here is the information about the specific database: Database: ternsjo_troff_prod DB-user: ternsjo_db_user HelioHost account: ternsjo Thanks in advance!
-
I am trying to make calls from python to a MySQL database using variables but the placeholder %s is not working. Here is my code: mycursor = connection.cursor() sql = "SELECT * FROM Users WHERE username = %s" val = ("Agwebberley") mycursor.execute(sql, val) myresult = mycursor.fetchall() print(myresult)
-
Is it possible to create a database through MySQL commands using PHP here? Look at this situation: I want the clients to create a database with the click of a button, containing several preset tables, using SQL commands inside PDOs in PHP. That being said, I want those databases to be created automatically, because this is part of a customized simple application.
-
Hi. I changed my password twice on Johnny. But from that moment on, I've never been able to connect to my database. This message shown on the top there: Error: SQLSTATE[HY000] [3118] Access denied for user 'munny'@'johnny.heliohost.org'. Account is locked. I'd like to know what I chould do to solve this problem as soon as possible. Thanks! -
Unable to connect to server: FATAL: no pg_hba.conf entry for host "115.98.208.177", user "kaatha_admin", database "kaatha_masterdb", SSL off
-
Hello everyone, First of all, thanks for this amazing service that you provide for free. I truly appreciate it. I wonder if it would be possible to deploy and run an ASP.NET Core web app on HelioHost. I've read that, for this, HelioHost provides the server "Lily", which is for Microsoft-related technologies such as this which I've already mentioned. The thing is that I'd also need some database because my app will need one. Preferably, I'd need PostgreSQL but if this isn't possible, SQL Server is my second option. I've already asked if I could have access to Johnny (to have a running PostgreSQL database there) and Lily (for my web app) but I've been told this isn't actually possible due to HelioHost's policy. Apart from this, I'd like to keep this web app accessible from a custom domain, let's say: www.my-incredible-app.com. Would this be possible with HelioHost (and Lily)? Thank you guys in advance! Edit - PD: my project will consist of Python scripts logging information to this database the web app will use, so remote access from for example my home IP (and not only from a web app hosted in HelioHost) will be needed. Still possible? :-)
-
Hello, guys! I have a huge data table, my concern is if I can't upload it to your server through PhpMyAdmin. This table contains the names of all countries, states and cities of the world. I need it because I'm implementing a sign up form and these data are strictly necessary. I know there must be out there other ways to retrieve that information. But... Is it possible to upload or import over 200MB of data to your PhpMyAdmin? If so, how can I do this? The file is zipped. Thank you
-
This question was changed to https://www.helionet.org/index/topic/36204-how-to-import-big-files-to-phpmyadmin/ Thank you
-
Hi! I just wanted to make a simple relationship between two basic tabes, that I've created. To make this action, I use "dbForge Studio for MySQL" but when I tried to create the connection, the software said the following: So, what to do? Your servers/setup do not provide to make foreign keys? Thanks for all!
-
Hello, my walter21_walter user is not able to query on tables with schema that is not public, I was only able to access tables within the public schema, even granting privileges to that user in other schemas, I want to know if I have to put the user walter21_walter as owner for all tables of all schemas?
-
Hi I've been trying to make a windows desktop application with visual studio using C# and i'm having trouble connecting to the mySQL database. my connection string is "Database=jackt_database;Address=johnny.heliohost.org;User Id=jackt_un;Password=*******" (obviously password isn't *******) the user ID has been added to the database and has been given all privileges. I've added the wildcard "%" to the remote mySQL section to allow connections from all IP addresses. I've tried resetting the password and changing it in my code multiple times. It is 100% not the code because i have tested it using a different host and it worked. // sql server connection here string constring = "Database=jackt_database;Address=johnny.heliohost.org;User Id=jackt_un;Password=********"; SqlConnection sqlcon = new SqlConnection(constring); try { sqlcon.Open(); MessageBox.Show("sqlconnection successful"); } catch (Exception error) { MessageBox.Show(error.ToString()); } finally { sqlcon.Close(); } i get the error "a network related or instance specific error occurred while establishing a connection to SQL server. The server was not found or was not accessible. Verify that the instance name is correct and that the sql server is configured to allow remote connections." later in the error it says "the network path was not found". Any help would be greatly appreciated. Cheers Jack
-
how to connect to sql by using php? Johnny Server $servername = "64.62.211.131";is this ip? or only type localhost
-
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.
-
Hi. My database's gone. Here's the data: user: sahdes server: stevie database: sahdes_wp52 Regards.
-
I got an Error in my Code that: 0 results: : Table 'ccraft50_db.MyGuests_Index' doesn't exist This is my code: <?php $servername = "localhost"; $username = "ccraft50_db"; $password = "my password"; $dbname = "ccraft50_db"; // Create connection $conn = new mysqli($servername, $username, $password, $dbname); // Check connection if ($conn->connect_error) { die("Connection failed: " . $conn->connect_error); } $sql = "SELECT id, firstname, lastname FROM MyGuests"; $result = $conn->query($sql); if ($result->num_rows > 0) { // output data of each row while($row = $result->fetch_assoc()) { echo "id: " . $row["id"]. " - Name: " . $row["firstname"]. " " . $row["lastname"]. "<br>"; } } else { echo "0 results: " . $conn->error; } $conn->close(); ?> How do I remove the database name in my Table?
-
Hi, my Sql database is missing. How can I get it back? Regards, Ales
-
What's happened to my http://demo.heliohost.org/wordpress/ it's always "Error establishing a database connection"? Is the MySQL server still have a problem or it's now fixed and just some of us experiencing this? How can I fix this? Thanks.. -
I'm having a problem with databases on Johnny that are used by a wordpress installation or three. I've made an account with the name jptsndbx to host a few small wordpress installations to play around with ideas for sites. Recently I've started upgrading them to wordpress 4.0, which involves an upgrade to the database. However, with two different wordpress installations now (each with their own databases), when I upgrade the site, I get an endless loop of "You must upgrade the database --&--#62; Thanks for upgrading the database, click here to continue --&--#62; You must upgrade the database" etc. After some research online, disabling plugins via ftp, etc, I found that the problem was buried in an sql table that listed a value that wordpress reads as the current database version. For some reason it wasn't updating. When I tried to change it myself, I get an "unspecified error." Anything I can be doing on my end to fix this?
-
It looks like after this 'A Dns Entry For Professionalserver.tk Already Exists' problem, I don't have now a capacity to upload my "phpDolphin.sql" file using the import function available in MySQL database.. This is what happened after uploading that SQL file: Can somebody fix my new issue? This problem is not existed when I'm in Johnny server. Okay here is what happening when I Check DB: MySQL Databases Checking Database mbdungo_phpdolphin is now being checked. mbdungo_phpdolphin.admin Error : Table 'mbdungo_phpdolphin.admin' doesn't exist status : Operation failed Check Complete -
Hi I recently found my site un-avaliable because MySQL was complaining of too many connections, I cannot understand this as there is no one using the site (to my knowledge) so I'm wondering if something's happening on Steve.
-
I am currently using helio to host my database as my other provider doesn't allow me to have remote connections. I require remote connections for my SQL database as i am currently working on a project. This project is a program. The program must be able to access the database and pull and submit values from my database. I am currently making the program in Microsoft Visual C# 2010 Express and i am having issues connecting to the database. here is my current code: static void Main() { using (SqlConnection myConnection = new SqlConnection("user id=lachee_admin;" + "password=SECRETWORDS;server=johnny.heliohost.org;" + "Trusted_Connection=yes;" + "database=lachee_BrutalGame; " + "connection timeout=2")) { try { myConnection.Open(); } catch { MessageBox.Show("Could Not Connect To Database", "Connection Error 001", MessageBoxButtons.OK, MessageBoxIcon.Error); } Application.EnableVisualStyles(); Application.SetCompatibleTextRenderingDefault(false); Application.Run(new Lobby()); } } For some reason, it cannot connect to the database. It states (when not surrounded my try and catch): I am sure that i have allowed remote connection to my database because I have inputted the wildcard (%). Is there anyway to connect? Does helio even support external program connection?
-
I've been trying all day to restore a backup of my SQL database, as when I was upgrading my site, something went wrong so I am going back to an old version. It's been, for the last hour or so now, sitting on a screen that says 'Restoring Database', but the page is completely blank besides that, and my DB isn't restored yet. Did I do something wrong? Or does it normally take a long time?
-
I want to use the Data Source Configuration Wizard in VB/Visual Studio to add a new database to a DataGrid control but don't know the Server Name, any ideas on what it can be?
