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.
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.
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 RelatedTrying 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]....
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]...
Is there any reason for the mysql user to need bash shell?
From /etc/passwd:
Code:
mysql:x:100:103:MySQL server:/var/lib/mysql:/bin/bash
Will anything break if I change that to /bin/false?
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?
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].....
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 RelatedI 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 RelatedI'm having a hard time to access MySQL from the local or remote shell.
If I try to access MySQL, using mysql -u root -pxxxx I get the error 1045 Access denied...
MySQL is running and I can access it, using phpmyadmin.
There must be something blocking shell access. Can anybody confirm and tell me how to check/configure for shell access?
I'm using ca preconfigured CenOS from PBX in a flash and it seems they did some security settings - but I can't find any further information.
I know I should probably post there, but the Mods didn't activate my account yet. And you know how it is if you try to figure something out. You won't stop.
I have a CentOS dedicated server running ProFTP. I have created user accounts which are meant for FTP access only but the users cannot connect to the FTP unless their shell access is /bin/bash
Here is an example line that is outputted when I use this command:
This user can access the FTP fine, but he can also access SSH which I don't want to allow him to do. If I set his shell access to /bin/false then he can't connect to the FTP.
What can I use in instead of /bin/bash to allow FTP but don't allow SSH?
I need to access the shell prompt rather than GUI of Ubuntu. I have installed Ubuntu in Microsoft Virtual PC 2007 Sp1 wherein installation is successfull. Now i have downloaded PuTTy to my WinXP Desktop. So by what IP can i connect with Ubuntu Shell. How to configure IP in both Ubuntu and in Windows XP so that this will look like i am accessing the shell remotely.
View 8 Replies View RelatedHow 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 RelatedHow do I create a new mysql user and a mysql database at the shell prompt?
View 1 Replies View RelatedI want to change my default shell to tcsh. I used
Code:
usermod -s /bin/tcsh username
command as given at url
But if I open a new shell, it is still a bash shell.
How do I make my default shell as tcsh?
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]....
Is there some type of functional way to read things in the Python shell interpreter similar to less or more in the bash (and other) command line shells?
Example:
Code:
>>> import subprocess
>>> help(subprocess)
...
[pages of stuff to read]
...
I'm hoping so as I hate scrolling and love how less works with simple keystrokes for page-up/page-down/searching etc.
I have install mysql on my fedora12. My different mysql server is located in us. I want to check health status and hits per seconds everything. Is it possible with mysql-administrator command.
now a these days i am connect through ssh and excuting below command
#mytop mysql -u root -p <passwd>
In my mysql db i have added the userip & passwd (allowed the privileages for that ip)
If i use mysql-administrator i am getting below error
MySQL Error Nr. 2003
Can't connect to MySQL server on '66.98.152.64' (111)
Is there any way I can switch my desktop shell from unity to, say, gnome-shell? I can switch using other console shell I like (bash, csh, fish, etc.). Assume that there is a stable alternative desktop shell, I should be able to choose, too.
(For console shell, we goes to /etc/passwd. But for desktop, I can't find the way to config.)
Running Ubuntu 9.10. In the Remote Desktop config dialog I get: "Your desktop is only reachable over the local network. Others can access your computer using the address 127.0.0.1 or tabatha.local." I understand this means only the loopback ip address is available. All my other machines show their true local ip address (e.g., 192.168.1.104) in this dialog. Thus I cannot log on to this desktop from other machines.
When I try to do a remote logon from another Ubuntu 9.10 box (or from an XP box using a VNC viewer), I get: "Connection to 192.168.1.102 has been closed." What steps are needed to make this machine show its actual ip address? All file sharing between the various machines is working properly and all windows shares back and forth between XP and 'nix, and among the the vaious XP boxes and linux boxes are available as designed.
Does it use Bash or some other shell?
View 2 Replies View RelatedI have 200+ mysql database dump in tar.gz format. Restoring all of them one by one is very time consuming. Is there any way so I can restore all these database in a single transaction.
View 1 Replies View Related1-what is the shell command which allows me to know how many opened sessions on a mysql server?
2- what are the important points we can manage in a mysql server?
I am trying a scenario for calling a shell script when ever a trigger is called. Can some one guide me how to achieve this scenario. Also it should passes the value from the table to the shell script. Can some one explain me along with the example.
View 2 Replies View RelatedI'm creating script to connect to mysql and perform function. I'm into process in querying mysql from shell. Here is the content of a sample script:
Code:
#!/bin/bash
USER=scripter
PASS=test123
DB=test_scripts
Code:
terminator557@Dissimulo:~/ieee80211-1.2.18$ sudo make INC=/path/to/kernel-headers/include/
Makefile:17:
Makefile:18: WARNING: $SHELL not set to bash.
Makefile:19: If you experience build errors, try
Makefile:20: 'make SHELL=/bin/bash'.
[code].....
I would like to create some aliases for bash shell. On other Unix/Linux machines I have done this using the alias command like this: alias rm rm -i
When I type that into a terminal on Ubuntu, it looks like alias is not installed. I get this:
bash: alias: rm: not found
bash: alias: rm: not found
bash: alias: -i: not found
I tried adding the alias to .bashrc instead, but then I get the same error message every time I start terminal. Just for fun I tried apt-get install alias, just to see what would happen, and it installed something called libperl-alias instead, and alias still doesn't work.
from nmap localhost | grep mysql command i will come to know whether mysql server is running or not.my problem is i want to test whether mysql server is running or not in shell script and if it is running i need to tell the user to stop the server to run the shell script.
View 3 Replies View Relatedi want to know how can i change the owner of the mysql data base with shell commands.
View 3 Replies View Related