General :: Install Mysql Query Browser In Debian?
Mar 17, 2011I want to install mysql query browser in debian
View 1 Replies
ADVERTISEMENT
General :: Run A Query Browser For Mysql - X11 Connection Rejected Because Of Wrong Authentication
Nov 17, 2010I am running Ubuntu 10.04 LTS. I am trying to run a query browser for mysql but keep receiving the following error:
X11 connection rejected because of wrong authentication.
The application 'mysql-query-browser-bin' lost its connection to the display localhost:10.0; most likely the X server was shut down or you killed/destroyed the application.
In ssh_config, I do have ForwardX11 set to yes.
OpenSUSE :: MySQL Query Browser For 11.4?
Apr 14, 2011Can query browser be installed in 11.4??
I've tried to use workbench but it's such a big step backwards in that you can't easily edit the output from a "select x,y,z from table" query. I'd have thought that was a pretty basic requirement...
Server :: MySQL Query Browser Connection Help
Jan 28, 2010i have MySQL on my CentOS server and have installed it and got it up and running through the command line.
I have changed root's username and password so there is no user called 'root' anymore. I also created a database called pancakes.Now when i try to log in using Query Browser, i put the server's IP in 'hostname', my new roots username and password in 'username' and 'password'.When i try to log in it gives me error 1130 and says connection from myhostname not allowed.
Fedora :: Get A Link To Download MySql Query Browser(windows Version)?
Jan 16, 2011Does anyone know where I can get a link to download MySql query browser(windows version)?
I want to query my database on my fedora box in windows to make life easier... I can not seem to find a link to download the query browser though
General :: Sqlite Query To Retrieve Browser History?
May 24, 2010This query is giving "Unable to open data base" can anybody suggest what's wrong with this query.
sudo echo "SELECT datetime(moz_historyvisits.visit_date/1000000,'unixepoch'), moz_places.url
FROM moz_places, moz_historyvisits
WHERE moz_places.id = moz_historyvisits.place_id;" | sqlite3 moz_places.sqlite, moz_historyvisits.sqlite
General :: Adding DATE_SUB To A Mysql Query?
Sep 21, 2010I have the following mysql query which works great.
Code:
SELECT msg FROM `logs` WHERE ((`host` = 'aaa.bbb.ccc.ddd') OR (`host` = 'aaa.bbb.ccc.ddd')) AND `msg` REGEXP CONVERT( _utf8 'physical addresses' USING latin1 ) COLLATE latin1_swedish_ci
I need to refine this query so that I can query the last # hours using the `datetime` field in the database. I have researched the DATE_SUB function and can query for example the last 1 hour like this:
[Code]....
General :: MySQL Slow Query Log Rotate ?
Jan 17, 2011I am on a CentOS 64 bit and used webmin to rotate MySQL slow query log. Now the thing is although logs are being rotated daily but the new log files being created are empty which means MySQL is unable to write them due to some reason. I have checked using "ls -l" that both permission and owner of files is same but still MySQL is not writing logs. What could be the reason?
View 10 Replies View RelatedServer :: Configure The Connection Dialogue Box In Query Browser?
Mar 8, 2010I have installed mysql package in ubuntu 9.04 .I have also installed the query browser software can someone tell me how to configure the connection dialogue box in query browser. also my friend is using ubuntu 8.04 when he writes mysql in terminal he can directly execute database queries there but when i try the same thing on 9.04 i get an error as "Access denied for user 'ravi'@'localhost' (using password: NO)"
View 1 Replies View RelatedGeneral :: Mysql Query With Unix Timestamp Error "check The Syntax Near The Between"
Jun 28, 2010Quote: select * from s_transaction Where between UNIX_TIMESTAMP('2010-06-28 15:40:00') and UNIX_TIMESTAMP('2010-06-28 16:00:00') and user_id = '15545941';
Is this the syntax correct to retrieve a particular user transaction between given time period? because "its return error check the syntax near the between"
Programming :: PHP & MySQL - Query A Database From The Web?
Apr 26, 2010I have created a database which stores students grades for different stages of a project. One of the stages of the project is the specification part. I have a simple bit of html code which is going to be used as the searching facility. I want the user to be able to enter their ID and then it will display only their results. At the moment, it is displaying the results for EVERY student because I cant seem to find the correct syntax for my statement.
Heres the HTML code
<html>
<head>
</head>
<body>
<body bgcolor="#6881bb">
<center>
[Code]....
At the moment when i click the button, no matter what I enter every students marks appear on the screen.
I think, but obviously dont know for sure because if i did i would know how to solve the problem, the code that i need to change is in green.
Programming :: Insert Query In Mysql ?
Jul 12, 2011When i enter this query to mysql:
Code:
return this error:
Code:
when i delete the insert part :
Code:
query is ok:
Code:
1 row in set (0.00 sec)
Programming :: Duplicate Value In Select - Mysql Query ?
Dec 2, 2010Trying to export a Mysql query to a .csv file the query draws from multiple tables, e.g. sales, purchase and currency
Code:
What i'm trying to do is to export both the sales and purchase to a single line where both the currency for the sales and the purchase is specified.
Basically like this:
Code:
Problem here is that i'm stating currency.value twice in the same select and don't know how to define which currency.value applies to sales and which to purchase.
Programming :: PHP / MySQL Statement - Query Result
Jan 29, 2011It is under PHP/MySQL
$queryresult = $conn->query("INSERT INTO normalrequests VALUES($finalkey, 1234, 5678, FALSE)");
It is connected to the database successfully but I feel there is something wrong with the statement up there.
Programming :: Send A Mysql Query Output Into An Array?
Jul 27, 2010i will be quick, im trying to send a mysql query output into an array ie:
Code:
declare -a HD
HD=`echo "USE db; SELECT uid FROM user" | mysql -u $login -p$pwd -h $dbhost -B`
echo ${#HD}
those vars in mysql connection are previously and correctly assigned.
but got an error
script.sh: 2: declare: not found
Programming :: Looping Over Mysql Query Results In Bash?
Sep 15, 2010I am querying a single string column in a table. The string values have spaces in them. I want to loop over each value in bash. I set IFS to split lists on newlines instead of spaces. When I try this, it is splitting the list of results on the actual character 'n', not the newline ''.
DATA=`mysql -u root -ppassword --silent 'SELECT name FROM table_a;'`
IFS=$'
'
for i in $DATA; do
echo "item = $i"
[Code]....
Programming :: Change A Mysql Query Result Prior To Display?
Oct 17, 2010I am not sure if this is possible. I have IP's stored in a mysql database. When I query the database, it returns the IP. I would like to replace the IP with something else prior to displaying the results. Is it possible even though I have not stored it in the database?
I have the following in a while loop (mysql_fetch_array).
Code:
<td align="left">' . $row[IP] . '</td>
Instead of displaying $row[IP] from the database, I would like it to display something else which I define in the PHP code but based on the IP.
ie. aaa.bbb.ccc.ddd = hostnameABC
Programming :: Split Mysql Date Query Or Hide Some Output?
Feb 22, 2011So I've got a rather vast database, one of the columns is date in the following format: DD/MM/YY HH:MM:SS. This is starting to cause problems with a php page I'm writing which asks the user for a 'start date'. Would it be better for me to split the date column into date and say time? Or is there a way of using distinct and masking the times.
View 10 Replies View RelatedCentOS 5 :: MySQL Subsecond Slow Query Log Patch Installation?
Aug 31, 2010I am using MySQL 5.0.77 Version rpm on CentOS 5 Red Hat Linux. I want to install micro second slow query log patch on this MySQL S/W version.As I found the slow query micro second patch on percona site i.e. [URL]step by step to install above mentioned patch with rpm based MySQL installation? Do we need MySQL source files to apply patch ?
View 13 Replies View RelatedGeneral :: Install MySQL Server On Debian While Offline?
Aug 29, 2011I'm a Linux newbie. I want to install mysql-5.5.15-linux2.6-x86_64.tar.gz on a Debian box offline without using the apt command. How can I do this?
View 1 Replies View RelatedServer :: MySQL Error 134 From Storage Engine Query: Select Data, Created, Headers?
Mar 1, 2011I need help about the error in my website. I have the following error....
Code:
user warning: Got error 134 from storage engine query: SELECT data, created, headers, expire, serialized FROM cache WHERE cid = 'theme_registry:database1' in /var/www/html/web/includes/cache.inc on line 26.
OpenSUSE :: 11.2 - Cannot Access MySQL Via Browser
Apr 21, 2010Since I installed SUSE 11.2 I have been unable to access MySQL via any browser although I can via MySQL Administrator. Firefox keeps asking if I want to open index.php with KWrite, it also occasionally asks this when I am on other sites. Konqueror gives an immediate timeout error.
View 2 Replies View RelatedDebian :: Best Way To Install Dillo Web Browser?
Jul 15, 2010Does anyone know if dillo can now be installed in squeeze/sid by adding an unofficial repository to synaptic or does it have to be installed (together with FLTK2) by following the instructions on the linked site?
View 6 Replies View RelatedGeneral :: Can't Connect To Local MySQL Server Through Socket '/var/lib/mysql/mysql.sock' (2)
Jun 2, 2010i am using liferay5.2(mysql included in the download pack) on fedora. while liferay is working fine but i cannot connect to mysql.i am getting the error
[
[root@localhost ~]# ln -s /var/lib/mysql/mysql.sock /tmp
[root@localhost ~]# /etc/init.d/mysqld start
Timeout error occurred trying to start MySQL Daemon.
[code]....
i didnt find the mysql.sock file in the location /var/lib/mysql/mysql.sock. i cannot find the portal-ext.properties file also to make intial settings.
Debian :: Install Chromium-browser In Squeeze?
Mar 28, 2011I am wanting to install Chromium-browser in Squeeze. I notice that it is in the stable repos, but it seems to be fairly out of date. I was wondering how difficult it would be to install it from the unstable repos and what the consequences of that might be?
View 1 Replies View RelatedDebian Installation :: Minimal GUI Install With Web Browser
Nov 1, 2014I have recently acquired a micro-sized-PC (A Dell FX130) which comes with a VIA C7 processor, 1GB RAM and 1GB onboard flash. The only application I need is a web-browser, I will use the FX130 to access a (very limited) number of web applications and to download/print-html-to-PDF - putting files onto a USB thumb-drive. I want to encrypt the disk to guard against tampering, and to run a restrictive firewall.
When I try to install the i386 debian-7.7.0 image - I run into the snag that it won't let me use guided configuration for the 1GB flash drive... and - when I guess at a sensible partitioning... I find that I run out of space during the standard installs. I note, however, that a whole bunch of significant applications (which I don't need) are being installed.
I am sure I'm missing something - is there an easy way to do a "minimal" GUI install that would make it easy to fit (just) a web browser (Chrome - ideally) and dependencies onto a 1GB bootable flash drive in a 'Debian-standard' fashion?
Debian :: Chromium Browser Install Ruined System - Way To Reverse?
Sep 1, 2011I've been using Debian for a month or so now and was really happy with it. I wanted to use Chromium browser and followed the instructions on the Debian wiki [URL].... but the install deleted a load of settings, network manager etc. Is there a way I can find a log of what happened? Is there a way to reverse that or shall I just reinstall?
View 6 Replies View RelatedDebian Multimedia :: Gnome Extensions Fail To Install Via Browser
Jan 26, 2014I'm using Debian Jessie and I'm trying to install some Gnome Shell Extensions from this site: [URL] .....
I click on the extension and it shows a button that I can turn ON or OFF. It's OFF by default. Then I click it, it turns ON and I'm asked if I want to download and install that extension. I say Yes! But then nothing happens. If I visit "Installed extensions" session, it says there are no extensions installed. And if I refresh the extension page, the ON button becomes OFF again. No matter how many times I try to do this, the result is the same. I tryed it with Iceweasel (v. 24.2.0) and Google Chrome (v. 32.0.1700.77) and default gnome-shell (v. 3.8.4).
Debian :: Error Trying To Install Mysql
Jul 12, 2010I'm trying to install mysql on Lenny. I managed to get apache and php going just fine but i'm getting this error for mysql at the mo: The following packages have unmet dependencies.
mysql-client: Depends: mysql-client-5.1 but it is not going to be installed
mysql-server: Depends: mysql-server-5.1 but it is not going to be installed
E: Broken packages
I don'thave a cluse how to fix this. I've read that adding a line in sources.
Debian :: Can't Access Mysql After Install
Jun 5, 2010I've just installed mysql-server (apt-get install mysql-server) in my debian vps, it ask for password of which i had provided. However after the install finishes, i run the command "mysql -u root -p", i entered my password but says "ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES".
View 3 Replies View Related