General :: Use MySQL Workbench On Dev Server?
Aug 15, 2010
Trying to use MySQL workbench on my dev server. Every time I try connecting I get: Can't connect to MySQL server on '192.168.1.101'
I'm using user josh with password testing. I set up the user with:
CREATE USER 'josh'@'192.168.1.100' IDENTIFIED BY 'testing'; and gave permisions:
GRANT ALL PRIVILEGES ON *.* TO 'josh'@'192.168.1.100';
my /etc/my.cnf looks like this:
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
[Code]....
View 9 Replies
ADVERTISEMENT
Apr 5, 2011
How can I use SSH to connect to my mysql server remotely? SSH connects on port xxxx, so do I need to forward ports in the putty connection?
View 4 Replies
View Related
Mar 6, 2010
I am currently running MySQL on my workstation under RHEL5 and would like an open community version of their Workbench. Is there an RPM binaries available? and/or can someone provide some direction on building from their source?
View 6 Replies
View Related
Jul 14, 2010
I'm trying to install mysql-workbench on RedHat 5 Desktop - this is what I was given, didn't pick it.I found an appropriate RPM that I downloaded from the MySQL site, but it's asking for several dependencies that I don't know how to track down.
Here's the error message I get:
Code:
]# rpm -ivh /home/confluence/Desktop/mysql-workbench-oss-5.1.18a-1fc11.x86_64.rpm
error: Failed dependencies:
libatkmm-1.6.so.1()(64bit) is needed by mysql-workbench-oss-5.1.18-1fc11.x86_64
libcairomm-1.0.so.1()(64bit) is needed by mysql-workbench-oss-5.1.18-1fc11.x86_64
[code]....
The packages that aren't installed, I'm just not sure what aI should be looking for to install them. how EXACTLY would you suggest I fix this? By exactly I mean, the dependency you are missing is part of the following package, type yum install "packagename" to fix this.
View 10 Replies
View Related
Oct 30, 2010
I'm running OpenSuse 11.3 which comes with MySQL Workbench V 5.12.16-8.2. This version hangs on connections and has several other behavior problems that others have reported. For several reasons, I need 5.2+ . As a relatively new regular user of OpenSuse, I've learned that it's much better for me if I work within the package environment (read: I've made mistakes and am willing to learn) so I'm reluctant to try to just load the Suse rpm off the MySQL.org site. So:is there a more recent release of Workbench in a repository I've not found yet? if not, what's the safest way to install this as an rpm that will not impact the rest of the package management system?
View 6 Replies
View Related
Feb 13, 2011
I have been trying to install the above on my CentOS 5.5 server but am having missing libs issues. Our friend yum is not helping either. Here're some of the libs missing:
Missing Dependency: liblua-5.1.so()(64bit) is needed by package mysql-workbench-gpl-5.2.31-2el6.x86_64 (/mysql-workbench-gpl-5.2.31a-2el6.x86_64)
Missing Dependency: libssl.so.10()(64bit) is needed by package mysql-workbench-gpl-5.2.31-2el6.x86_64 (/mysql-workbench-gpl-5.2.31a-2el6.x86_64)
Missing Dependency: python(abi) = 2.6 is needed by package mysql-workbench-gpl-5.2.31-2el6.x86_64 (/mysql-workbench-gpl-5.2.31a-2el6.x86_64)
[Code]...
View 5 Replies
View Related
Jul 10, 2010
I'm trying to install workbench on my opensuse 11.2 x64 bit version but I got a problem with python available version on opensuse is 2.6.2 and the required version is 2.3.
how Could I solve this?
View 1 Replies
View Related
Jul 28, 2010
Code:
./schema_editor_fe.cpp:116: error: 'Gtk::EntryIconPosition' has not been declared
./schema_editor_fe.cpp: In constructor 'SchemaEditor::SchemaEditor(grt::Module*, bec::GRTManager*, const grt::BaseListRef&)':
./schema_editor_fe.cpp:73: error: 'class Gtk::Entry' has no member named 'set_icon_from_pixbuf'
[code].....
View 1 Replies
View Related
Jun 1, 2010
I have a python & sqlite2 application called "gourmet recipe manager" running under 10.04. If I try to install MySQL Workbench, Gourmet is uninstalled without so much as a 'by your leave'. When I reinstall Gourmet, MySQL Workbench is similarly abruptly uninstalled. Why?
View 2 Replies
View Related
Aug 3, 2011
I just downloaded MySQL-Workbench and I see it in the folder: Code: /usr/bin how do I access it from my desktop without having to tie up my bash shell because the only way I can get to it right now is
Code:
cd /usr/bin
mysql-workbench
and only when I close the program can I use my bash for anything else.
View 7 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 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
Aug 25, 2010
Scenario:A - Local Unix machineB - socks proxy server port 1080C - remote mysql server port 3306I want to connect to the remote mysql server(C) from local unix machine(A) using sock proxy(B).
View 1 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
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
Feb 22, 2011
I've been attempting to set up a LAMP for local web development, which meant installing mysql-server. But now have a problem when trying to run mysql, I get:-
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
When trying to downgrade mysql-server I saw that there are dependency problems between the various modules (but can't recall which). But whichever route I truied the results are always the same.
Thought about trying XAMPP but I note that even has it's problems, is there any way I can get a lamp set up on FC14, or must I give it up as a bad job.
Howver, just been trying to again to fix the problems with downgrading mysql and get:-
Error: Package: mysql-server-5.1.55-1.fc14.i686 (@updates)
Requires: mysql(x86-32) = 5.1.55-1.fc14
Removing: mysql-5.1.55-1.fc14.i686 (@updates)
mysql(x86-32) = 5.1.55-1.fc14
View 7 Replies
View Related
Aug 2, 2010
I'm trying to setup wordpress on my server, which of course I need mysql for. I setup a database the other day, which worked perfectly, but I had to start again as I put some information in wrong. Now, I can create a database fine, but when I run
Code:
GRANT ALL ON wordpress.* TO wordpress@localhost IDENTIFIED BY "password";
I get the output:
[code]...
View 13 Replies
View Related
Jun 4, 2009
I have MySQL 5.1.34 and PHP 5.1.6 installed on my system, how do I install php-mysql? Each time I try, it says
mysql-5.0.45-7.el5.i386 from base has depsolving problems
-- > mysql conflicts with mysql-server-community
error: mysql conflicts with mysql-server-community
View 16 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 30, 2011
I installed mediawiki the other day and went with the default innodb option. However a week later something went wrong. And since I have scripts that nightly backup /var/ I just copied the backup of /var/lib/mysql/wikidb/ (as I've done with MyISAM). Then when I connect the wikidb database. I can see the tables (via "show tables"), but when I do any query with them (check table X, select * from X) I get:
Code:
Table 'wikidb.X' doesn't exist I've since read that can can't just copy the database directory like MyISAM, and there appears to be no way that I can find to restore or fix Innodb, without a dump of the data. And I never got a chance to do a mysqldump of the data. So has anybody got any idea how I can at least view the "page" table from the files I've backed up in /var/lib/mysql/wikidb/ ?
View 1 Replies
View Related
Mar 3, 2009
I just configured a complete Cent OS 5.2 system for use as a web server. I can configure Apache and PHP but MySQl seems to be causing some issues -
[mysqld]
datadir=/var/lib/mysql
socket = /var/lib/mysql/mysql.sock
user=mysql
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
[Code]...
View 16 Replies
View Related
Jul 14, 2010
I am using CentOS5 and installed the MySQL for server during the installation. I can set up and use MySQL databases. But I cannot make it startup everytime the server restarts. And quite a lot of methods need this folder "support-files/mysql.server", while my set up cannot find this. I am wondering if my installation of the MySQL for server is complete or not.
View 4 Replies
View Related
Aug 6, 2010
I want to learn mysql ! i have a pc with no lan/wan connections (i mean no server-client relation) i installed mysql using synaptic , when it was installing mysql,it asked me for password (opened a window) then i typed in terminal
output is :
View 3 Replies
View Related
Feb 28, 2010
I've been doing XHTML/CSS for the past several weeks, and started learning PHP last week (all on windows). Learned how to set up IIS server, mysql and php to be able to do all the work locally. Now, I've got Ubuntu 9.04 on my laptop and want to continue working with the book I have on it, so I can do some of the work when I'm away from home as well. Questions I have are:
1. How to set a server up?
2. SQL? (mysql?)
3. php? How do I check if I already have any of those installed on my system, and if not how to set them up?
4. where would the root system be for the server if I have it, or if not, where will it be?
5. do I refer to it as "localhost" here aswell i.e. [URL]
View 3 Replies
View Related
May 28, 2010
I'm trying to start the mysql server on fedora 12. service mysqld start gives me an error:
MySQL Daemon failed to start.
Starting MySQL: [FAILED]
More details
[root@localhost mysql]# which mysql
/usr/bin/mysql
[root@localhost mysql]# mysql --version
mysql Ver 14.14 Distrib 5.1.46, for redhat-linux-gnu (x86_64) using readline 5.1
And also I get a weird pop in the notification area regarding some security threat
SELINUX is preventing /usr/libexec/mysqld "read" access on plugin.frm
View 2 Replies
View Related
Nov 9, 2010
I'm trying to build a server using the SME distro and MySQL. Following the tutorials for MySQL, I need to have certain software installed. How do I know what programs I have installed?
View 3 Replies
View Related
Jan 8, 2010
I am facing a problem in my already installed mysql server so i want to uninstall it so that i can again install it.Can anybody tell me the steps or process how to do that.
View 1 Replies
View Related
Jan 7, 2009
I have yum installed mysql 5 on Centos5 and I can successfully run queries through shell.However, I want to now allow external access to mysql via some mysql tools (Mysql Administrator/Mysql Query Browser) which is on some windows machines on the same network.Mysql is running on port 3006.When i try connecting through mysql Admin i get the following:Could not connect to the specified instance.MySQL Error Number 2003Can't connect to MySQL server on 'ipaddress' (10065)If you want to check the network connection, please click the Ping button.Googling this I get the impression its something port related, but I have tried what I have found and still no go.When I ping the server I get:
Start Pinging:
Reply from ipaddress: Time=0ms TTL=64
Reply from ipaddress: Time=0ms TTL=64
[code]....
View 5 Replies
View Related
Mar 3, 2010
Is there a non-root, portable distribution of MySQL for Linux? I need to do some testing on a server that I do not have root access to.
View 2 Replies
View Related