Ubuntu :: Cannot Run MySQL Client Tool
Sep 1, 2011
I have installed MySQL server via Synaptic Package Manager successfully and I also installed MySQl administrator to check for MySQL installation. It is all there. And I ran this also, where "mysql" is a client tool:
hpng@hpng-laptop:~$ sudo mysql
[sudo] password for hpng:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
I entered my ubuntu user password, and I get access error. I have 10.04 LTS version.
View 3 Replies
ADVERTISEMENT
Apr 2, 2009
I have the latest LAMP running on F10 but need to do a database conversion from mysql 4.1.22 to mysql 5 for a client.
View 4 Replies
View Related
Mar 25, 2010
Specifically I'm looking for a native Linux program that is similar in functionality to Navicat or SQLYog. I.e. I need something good at editing data. Free would be best, but not essential.
View 9 Replies
View Related
May 2, 2011
I'm looking for commandline monitoring tool for mysql and only thing I can find is mtop. Unfortunately, mtop's development halted back in 2004. Can someone suggest an alternative? or is there such thing?
View 2 Replies
View Related
Feb 8, 2011
I'm looking to import hundreds of email messages stored in mbox format into a MySQL database. Is there a tool out there to do this already? I'd rather not reinvent the wheel if at all possible. I've been using HyperMail to archive my email in HTML format, but the results aren't searchable. I figure that once it's all in MySQL I can write some simple queries to accomplish this.
View 1 Replies
View Related
Nov 24, 2009
I'm looking for a graphical database management tool that will allow me to create some tables and whatnot. I'm looking for an application similar to Toad: http://www.toadsoft.com/toadmysql/
Does anyone know of a similar program for Linux?
View 5 Replies
View Related
May 30, 2011
As it says in the title I need to use the scalpel file recovery tool, or something similar to be able to recover a lost mysql storage folder.. The system crashed, and I really need these files as fast as possible. So I would love any help I could get.I have been searching in different search engines (including this forum) for an answer to my question, but I can't seem to find it.How can I configure scalpel, or any other similar application to be able to recover my mysql /var/lib/mysql storage directory. I really need these files... And.. I know, I should have taken backup
View 4 Replies
View Related
Mar 14, 2011
I work on Linux Regression testing and I am writing a script to automate(shell scripting) the netperf tool when I need to determine the performance(throughput) of agent and client(individually) and I shall be running a shell script on (lets say) client first. But how to obtain the synchronization between them both as I need to execute a command even in board(agent) side to get the script going.
View 1 Replies
View Related
Mar 25, 2010
Managing MySQL servers can be quite complicated without a proper tool.I have used some commercial tools over the years, but I need something that is Web based, accessible from internet.There are NOT many offerings out there, so I wonder if, beside one company that launched a product quite recently (Novaquantum), there is something else out there that can I can compare it with?I guess when you find something that you like, you'll always to look for something better (PhpMyAdmin doesn't count!)
View 2 Replies
View Related
Dec 3, 2010
I am using MySQL version 5.1.47 (64bit) on Centos 5.5 in production environment. I am exploring option to monitor MySQL though SNMP traps. Can anybody please let me know if there is any open source SNMP tool that can be used for MySQL monitoring?
View 4 Replies
View Related
Sep 29, 2010
[URL]
I just removed mysql-client after installing php5-mysql and my php is connecting to my remote server fine. What is the purpose of mysql-client? Is it a direct API for external servers?
[URL]
So it's basically /usr/bin/mysql that allows connection to external servers
View 1 Replies
View Related
Jul 23, 2010
I'm using debian 5 x64 with xfce.Is there a way to configure (start/stop/restart) services (especially Apache2, mySQL and PHP) using a graphical or cli tool? I tried to use sysv-rc, sysv-rc-conf, rcconf and rc-conf in the terminal but Bash didn't find them (Although Synaptic show that sysv-rc is installed).
View 9 Replies
View Related
Jun 13, 2009
i want to know how to configure my sql server and clients in debian 5. what should be the server host name and root password
View 1 Replies
View Related
May 3, 2010
I've got Fedora core 12 - I'm ex windows user.I have these 3 websites to maintain.These are in finnish language. So called pikalaina sites: Now I would like to add some database driven functionality to these sites.I don't wanna use command line - too dangerous for type errors.MySQL own programs is not very good.In windows I used to use MysqlYog, it was nice.Is there a good graphical MySQL client available for Fedora core 12 ?
View 2 Replies
View Related
Nov 16, 2010
I was installing a 2 server cluster ISPConfig3 with the help of GlusterFS. I was following this manual - Link
In the server the file /etc/glusterfs/glusterfsd.vol
Code:
# Configuration for the mysql server volume
volume posix-mysql
type storage/posix
option directory /media/big/myweb/export-mysql
[Code].....
View 3 Replies
View Related
Jul 27, 2010
I wish to connect to MySQL using an ODBC connection and I'm using isql to test. On the server connection using isql to local host is sweet however the problem is the client.Okay my set up looks like thisOn the server /etc/odbc.ini is[MySQL-scopus2008]Description = MySQL citation databaseDriver = MySQLServer = localhostDatabase = scopus2008Por
View 4 Replies
View Related
Aug 4, 2011
I have recently installed centos 5.6an app i have needs to run php 5.3 so i upgraded by adding a repo and using yum install php53*a php -v gives me this.PHP 5.3.3 (cli) (built: Mar 30 2011 13:51:41) Copyright (c) 1997-2010 The PHP GroupZend Engine v2.3.0, Copyright (c) 1998-2010 Zend Technologiesi also need mysql 5.1 so i picked a repo that had the 5.1 version of mysql in it and um install mysql*which gives me this.[root@localhost var]# mysql -Vmysql Ver 14.14 Distrib 5.1.52, for redhat-linux-gnu (i686) using readline 5.1and then tri to run my app and it failsthe only difference i see between the server that is current working and the new one is in the phpinfo file.in the mysql section of the working one it says Client API version. 5.1.xin the new server install it says the following which is still point to the client api or 5.0
mysql
MySQL Supportenabled
Active Persistent Links 0
[code]....
View 8 Replies
View Related
Sep 18, 2010
Summary: Does a discrepancy between MySQL client library 5.0.x and MySQL server of 5.1.50 cause "inconsistent behavior", as reported by phpMyAdmin? The longer version: Windows Sysadmin taking the plunge into Linux. I tried to spare you all the rookie questions and did a fair bit of reading. I'm rather happy I was able to get CentOS 5.5 installed and running, configured iptables, got the kernel updated, Apache, MySQL and PHP installed. Then upgraded PHP to 5.2 after I figured out how repos and priorities work.
I got phpMyAdmin installed and running, then decided to upgrade from 2.11 to 3.3.7 but it keeps complaining that my MySQL client libraries are something like 5.0.63, while my server is 5.1.50, and this may cause "inconsistent behavior" or something of the like. So, feeling industrious, I decided to find an updated client.
MySQL-client-community-5.1.50-1.rhel5.i386.rpm
But it wouldn't let me install it as it conflicted with the default mysql-server installation. I also couldn't remove just the old client, to update to a newer one. So I blew away everything mysql on my server and installed the above client
MySQL-server-community-5.1.50-1.rhel5.i386.rpm
and that server file. I'm assuming I'm missing dependencies now as phpMyAdmin claims it can't load the mysql extension. Attempting to 'yum' php-mysql tried to install 'mysql' as a dependency, which immediately conflicted with the files I'd installed. At this point I'm wondering if I'm closing in on successfully installing a version that phpMyAdmin doesn't complain about, or if I should even care that it is complaining and just go back to all the repo versions of everything.
# rpm -e MySQL-shared-community-5.1.50-1.rhel5.i386.rpm
error: package MySQL-shared-community-5.1.50-1.rhel5.i386.rpm is not installed
View 4 Replies
View Related
Jun 7, 2011
I think this goes here, but I'm not sure. I decided that XAMPP had been troublesome enough. MySQL never worked. So I decided to instal the LAMP stack offered by YaST. I went about installing it thinking that it would all work. But it seems that I was wrong. So I try to start mysql, and here's what I get:
Code:
the-matrix:~ # mysql start
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' (2) or
Code:
the-matrix:~ # rcmysql start
Starting service MySQL warning: /var/mysql/mysql.sock didn't appear within 30 seconds
chmod: cannot access `/var/run/mysql/mysqld.pid': No such file or directory
[Code]...
View 6 Replies
View Related
Jun 2, 2010
i 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.
View 9 Replies
View Related
Jun 17, 2010
I have installed Mysql in Ubuntu 9, for the use of roundcube database.After installing iam getting the error like this
* Stopping MySQL database server mysqld [ OK ]
* Starting MySQL database server mysqld [ OK ]
* Checking for corrupt, not cleanly closed and upgrade needing tables.
So because of this in the roundcube configuration its giving the error message that MYSQL is not installed. So Kindly give me a idea how to solve this.
View 1 Replies
View Related
May 26, 2011
I have configured server ubuntu 11.04. Everything works fine, but there is a need for some clients to connect local hard drive. What should I do? How and what modules are added to the ltsp-image? How to register in the fstab on the client? Maybe I'm going the wrong way?
View 1 Replies
View Related
Jan 14, 2011
i was trying to allow remote access to mysql by following mysql was running perfectly until i got here :
Code:
/sbin/iptables -A INPUT -i eth0 -s 192.168.1.0/24 -p tcp --destination-port 3306 -j ACCEPT
i changed my.cnf bind-address line to : "bind-address = 127.0.0.1" and nothing
[code]....
View 4 Replies
View Related
Sep 26, 2010
getting foll error during 'make' part of compilation of mysql v5.5.6rc
Code:
libtool: link: unsupported hardcode properties
libtool: link: See the libtool documentation for more information.
libtool: link: Fatal configuration error.
code....
View 9 Replies
View Related
Jun 18, 2010
I was having issues with MySQL Server and uninstalled it. I still have my databases at /lib/var/mysql.
My question: if I install MySQL Server (same version, 5.1) again, will it delete my databases, or will they still work?
View 1 Replies
View Related
May 23, 2011
How can I really, really remove everything related to mysql / mysql-server. I read and tried all kinds of things, but on every reinstall there is still old mysql stuff there, for example an existing password. Even resetting the password does not help.
Reason of removal: it looks like the mysql setup is really corrupt, so I want to remove, and then do a fresh install. Running Ubuntu 11.04 64-bit
sander@R540:~$ sudo apt-get purge mysql-server
Reading package lists... Done
Building dependency tree
Reading state information... Done
Package mysql-server is not installed,
[Code]....
View 4 Replies
View Related
Jan 6, 2011
trying to create a "local network" by directly connecting an IBM Thinkpad with Debian Linux installed on it to an Alix computer running Voyager Linux. I'm following a "how to" I found to create a music server, hence the requirement. My issue is I can't get a static IP address to be configured on the Debian machine.I've trawled the net and have found the instructions about editing the /etc/network/interfaces and have tried to do this. First I tried to get DHCP working so I could connect the Debian machine to the net and this proved successful. I edited the interfaces file to look as follows:
# The loopback network interface
auto lo
iface lo inet loopback
auto eth0
iface eth0 inet dhcp
Then I tried adding a static IP address to the machine. As this is a network purely between two machines I made up the IP addres and used 192.168.0.1 and used a NetMask calculator to give me a NetMask of 255.255.255.254 (I told the calculator there would be 2 machines on the network). I then edited the interfaces file as follows:
# The loopback network interface
auto lo
iface lo inet loopback
[code]....
I re-booted the machine (ifdown eth0 followed by ifup eth0 keeps saying that eth0 hasn't been configured - a problem there that I don't understand), but during boot up time it failed to assign the Static IP address to eth0 and made me go into SU mode. To fix it I simply replaced the interface file with the static IP inputs with the file that had the DHCP entries (I'd made a copy of the DHCP file), and re-started the machine. Everthing came up fine. So the first question is how do I get a static IP address to be assigned to eth0 such that whenever I shut down and restart the machine the static IP address is always loaded?
The second question is around creating the network via the cross over cable. From what I've found via Google, all I should have to do is create a static IP address on the Debian machine and a static IP address on the Voyager machine. Once they're connected by the cross over cable they should see each other. Is that correct, or do I have to do anything else?
View 2 Replies
View Related
Mar 9, 2011
I am writing a TCP server in C, and the server listens to incoming client connections and accepts them. It then creates a thread to handle the client. The clients are expected to only receive data from my server and not send any data. So if I use a select() call with a recv(), I believe that the recv() will just block forever since there will not be any data coming from the client. If I use a non-blocking recv(), then this will just return a 0 which tells me nothing because the client is not expected to send any data. I am not sure if I have misunderstood some socket concepts, but I need a solution to detect when the client has disconnected so that I can close the socket and stop sending data to the client. As I understand it, simple ACKs etc are not captured by the recv(), and only data sent by the client will cause recv() to return a non-zero value, so I am not sure how to know when the client has disconnected.
View 7 Replies
View Related
Aug 25, 2010
I'm having problems connecting to the mysql database on my system. I first noticed this when I was trying to set up the program anymeal. I subsequently tried using MySQL Administrator (mysql-admin), but had no luck. It gives my the following feedback:
Code:
Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Click the 'Ping' button to see if there is a networking problem. I press the ping button, and it seems to connect.
Code:
View 4 Replies
View Related
Dec 6, 2010
I've downloaded and installed MySQL-client-5.1.53-1.glibc23.x86_64.rpm. I'm rather new to linux so it might be I haven't started the server. Unfortunately I have no idea which file is responsible for that. It is also possible that my head isn't functioning correctly ( if at all ).
Error I receive is:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
View 6 Replies
View Related
