Stack Overflow
Stack Overflow

Questions tagged [sqlbuddy]

SQL Buddy is an open source tool written in PHP intended to handle the administration of MySQL over the World Wide Web. It can perform various tasks such as creating, modifying or deleting databases, tables, fields or rows; executing SQL statements; or managing users and permissions.

Overview

SQL Buddy is an open source tool written in PHP intended to handle the administration of MySQL over the World Wide Web. It can perform various tasks such as creating, modifying or deleting databases, tables, fields or rows; executing SQL statements; or managing users and permissions.

Features

  • Create and drop databases and tables
  • View, edit, insert and delete table rows
  • Execute custom SQL and view the output
  • Import and export databases and tables to SQL and CSV formats
  • Add, edit and delete MySQL users
  • Ships with 47 translations (including Esperanto!)

Requirements

Installation

  • Download the file above and unzip it
  • Upload the sqlbuddy folder to your web server
  • Point your browser to the sqlbuddy folder
  • Log in using your existing MySQL credentials

Links

20 questions
6
votes
2 answers

How to use foreign keys in SQL Buddy?

I need to use foreign keys for update and cascade, etc. ALTER TABLE topics ADD FOREIGN KEY(topic_by) REFERENCES users(user_id) ON DELETE RESTRICT ON UPDATE CASCADE; but I am not able to make foreign keys in SQL Buddy. Any way to do that?
Sahil Manchanda
  • 79
  • 5
4
votes
1 answer

SQL Buddy Export to file "The file could not be opened"

I installed SQL Buddy on my localhost and it has worked really well in place of phpMyAdmin, but the one thing I'm having issue with is when I need to export a database and choose to export as a file (Output to: text file), it is giving me an error…
Tri Nguyen
  • 9,950
  • 8
  • 40
  • 72
2
votes
1 answer

Sqlbuddy login not working with PHP 7.0

I have searched for an answer to this, but haven't found anything. I was wondering if anyone had come across the same issue and had any insight. I have PHP 7.0 installed on an nginx web server with sqlbuddy. When attempting to login to the…
Informagician
  • 305
  • 3
  • 15
1
vote
1 answer

Cannot Login sqlbuddy on Ubuntu localhost

I installed lamp server into my Ubuntu 16.04 via tasksel. After then I downloaded sqlbuddy and set it up to /var/www/html. I called following link (localhost/sqlbuddy) that appeared SqlBuddy Login Screen. I logged in as Username: root and left…
Zox Zin Min
  • 11
  • 2
1
vote
1 answer

Completely exlude subdomain with Varnish

Scenario: I have an Apache/Varnish setup with a number of different subdomains. Every subdomain has its own VirtualHost-file in sites-enabled but all run in the same Wordpress installation. Except for one: sqlbuddy.mydomain.com, which is a…
user5747873
  • 359
  • 1
  • 2
  • 9
1
vote
0 answers

PHP Errors when Accessing Sqlbuddy

As a bit of a side project, I've been following a guide on how to set up an Nginx web server from here: http://arstechnica.com/information-technology/2012/12/web-served-part-4-get-your-database-on/2/ Everything went fine until I installed Sqlbuddy.…
Flawedspirit
  • 413
  • 1
  • 5
  • 9
1
vote
0 answers

Sqlbuddy show very slow responsetimes

i don't know if this is the right place to ask a question but i'm going to try anyway... I was looking for a leightweight alternative of phpmyadmin and found sqlbuddy. Very good performance at first an very customizable. However, since a few days it…
Kenny Bloem
  • 91
  • 1
  • 1
  • 6
0
votes
1 answer

sQl buddy: you have an error in your SQL syntax;

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 'charset utf8 not null auto_increment index key, toId int(11) charset utf8 not ' at line 1 This error i am getting…
Toni Michel Caubet
  • 19,333
  • 56
  • 202
  • 378
0
votes
1 answer

change default login information for sqlbuddy

I'm trying to edit login.php for sqlbuddy and not having any luck. I want to change the default host and user name that it prefills the login page with. I've tried changing these lines but the page doesn't change. :( Can someone give me a hint or…
AaronJAnderson
  • 1,698
  • 4
  • 18
  • 25
0
votes
1 answer

Resolve Javascript Conflicts / jquery

I am trying to add jQuery to the PHP of SQLBuddy and am getting some conflicts. If I just include jQuery, the rest of the program stops functioning and doesn't pull the tables / databases. If I use the jQuery noConflict function, everything works,…
Alan
  • 2,046
  • 2
  • 20
  • 43
0
votes
1 answer

Editing user permissions or restoring SQLBuddy to default, for Wampserver?

I accidentally locked myself out by creating a new user account (with what I thought had full privileges) and deleting root altogether instead of editing it. I'm not the brightest bulb in the box sometimes. Basically, how can I restore my full user…
HB-
  • 635
  • 2
  • 8
  • 21
0
votes
1 answer

SQL statement in php will not insert onto database

I have this SQL statement that i'm trying to get to save new students to a table of students, however it simply isn't doing it, I don't get any error messages when I run error reporting and I ran the Query in sqlbuddy with values swapped in and it…
Benjamin Sealy-Minto
  • 39
  • 10
0
votes
3 answers

SQLBuddy: How to select database?

I have the following sql which I want to import with SQLBuddy. However I get an error telling that no database selected. Could anyone tell me what line I need to add please? CREATE TABLE IF NOT EXISTS `jos_banner` ( `bid` int(11) NOT NULL…
shin
  • 31,901
  • 69
  • 184
  • 271
0
votes
2 answers

Cannot access sqlbuddy on nginx server

I installed sqlbuddy following the guide by arstechnia, but I cannot seem to access sqlbuddy. This is the setup for /etc/nginx/sites-available/www server { listen 80 default_server; listen [::]:80 default_server ipv6only=on; …
Username19
  • 45
  • 1
  • 5
0
votes
0 answers

Does phpMyAdmin SQL command differ from sqlbuddy?

I'm learning php/mysql, I have made a php page and I have a form on a host that has a sqlbuddy database, when I ws a adding a column in the table but the I got this: You have an error in your SQL syntax; check the manual that corresponds to your…
Sello
  • 297
  • 1
  • 8
1
2