1-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?
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?
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 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.
My co-worker and I are working on this robotics project where robots are controlled over the web. I don't want to go into all the details, but basically the users visit a page where they have access to a PHP-based interface that allows them to send commands to robots in our tech lab (via an intermediate server). Our web server is running Apache.
Anyway, now we need to implement session control, with user-names and passwords so that only certain people can have access to the interface at a certain time, with access to only certain robots, et cetera. We were hoping there was some kind of pre-fab FOSS solution for handling both the session control and maintaining the MySQL user/password database.
My co-worker knows a little PHP, and I know a little MySQL, but we are both noobs enough that we would prefer to do as little of this from scratch as is possible. We don't have a lot of time, and I know it is easy for inexperienced MySQL programmers to introduce security vulnerabilities.
How do I create a new mysql user and a mysql database at the shell prompt?
View 1 Replies View RelatedI know PHP auto removes stale sessions on it's own, but that doesn't remove them from the MYSQL table. So I was gonna make a cron script that ran once every hour that removed any MYSQL shopping cart item from the table if the original session_id that created it does not exist anymore.
From my understanding a session_id is an "actual" file located somewhere on the harddisk (is it not? correct me if I'm wrong), so I was going to do a simple check for each item in the shopping cart to check for it's original session file, if it didn't exist on the harddisk, then simply remove it from the mysql table.
what is the correct command on a mysql command line to alllow mysql to alllow remote connection on a server
View 1 Replies View RelatedI have 2 servers, let say server1 and server2. I have create ssh-keygen from server1 to server2, I can ssh from server1 to server2 without typing a password. My question is: How can I use command from server1 to server2? for example I want to list file in server2 /home directory from server1.
View 1 Replies View RelatedI want to create for my private use, a simple web interface to manage some easy task (useradd, userdel, passwd, etc...).I have some basic knowledge of PHP; how can I realize this? PHP as module or CGI? Which is better in this case?
View 12 Replies View RelatedAs homework for my study I have to do some kind of browser GUI to send commands to mysql command line tool and to show the output in the browser. I already set up sudo to have the right permissions for the www-data user. In the php documentation I found that one of the following four commands are probably for tasks like mine.
exec
passthru
shell exec
system
Can anyone tell me which one is the best for my requirements? The idea is to use php from the browser to connect to mysql like on the command line with: "mysql �user=username �password" And then give back the output of the command line to the browser. If the above is working then the next step would be to put a link in order to execute the command �show database;� again through php by clicking that link. After clicking this link it would give back to the browser what the command line would display.
I am fresh out the box to linux I am using mysql for the 1st time also, my question is what is the correct command to run on a mysql command line to connect to remote server.
View 5 Replies View RelatedMy computer has broken and I cannot login. I don't know what caused it.
I am using Fedora 14 and so it is easy to retrieve my files with the Fedora 14 installation disk under the 'restore' option. I cannot however, work out how to retrieve my MySQL data.
Would anyone be able to shed some light on this matter?
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]...
I am new to shell scripting..I really need ur help or guidance here..I have a text file where i have to use dos2unix command.
Now the problem is how do i pass dos2unix command in the shell scripting after it had read the text file ??
And give out the new text file.
how can I display all databases and their size using command lines (linux) in a mysql server?
View 3 Replies View Relatedi 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.
I want to connect to an FTP server from the Linux command line. The server is configured behind a proxy.
If I call:
echo $ftp_proxy
I get a result like this:
abc.def.ghi.jkl:8080
If I call:
ftp -pn $ftp_proxy
I get a unknown host error.
How can I connect to the FTP server using the Linux command line?
I'm trying to connect OpenVPN server using shell command.
I've installed all needed packages (I guess)
if type
Code:
sudo openvpn client.ovpn
and i've got messages:
Code:
Mon Feb 15 12:29:25 2010 OpenVPN 2.1_rc19 i486-pc-linux-gnu [SSL] [LZO2] [EPOLL] [PKCS11] built on Oct 13 2009
[Code]....
but i can't see tap0 interface and cannot ping any address at remote location.
I tried this config file at Windows OpenVPN client and all works fine.
1-Can I have the shell command which allows me to have the number of reques ts/seconds under the Apache server?
2-And the number of sons threads in service/wait?
I want to find a way to bring up the session menu without using the Indicator Applet Session in the default gnome panel. I've figured out how to do this for the main menu with a keyboard shortcut (Alt+F1). And I found Ubuntu documentation here that says Super+Esc will bring up the Sessions Menu in Lucid but it doesn't work for me. I could create a custom launcher if I knew what command would bring up this menu but I can't find any info on this. Basically I want to get rid of the default gnome panel but still have the functionality of the Sessions Menu.Note: I removed the Me Menu from my Indicator Applet Session by running sudo apt-get remove indicator-me in a terminal. Would this be interfering with the keyboard shortcut?
View 2 Replies View RelatedI am very new to shell scripting.How does one pass a command-line parameter to a shell script?for the below program
#/bin/bash
mount -t cifs -o user=ramkannan,password=Linux123@ //10.200.1.125/ramkannan /MT
cd /MT/test
date=`/bin/date "+\%Y-\%m-\%d-\%H-\%M-\%S"`
mysqldump -uroot -pram2@ employeedb > $date.sql
gzip $date.sql
I want to pass parameter for everything,i tried in google and did but iam getting error while passing parameter to all
#/bin/bash
mount -t cifs -o user=$1,password=$2 //10.200.1.125/ramkannan /MT
cd /MT/test
date=`/bin/date "+\%Y-\%m-\%d-\%H-\%M-\%S"`
mysqldump -uroot -pram2@ employeedb > $date.sql
gzip $date.sql
i was getting error while passing parameter to all.
I have mysql downloaded and when I type mysql into the command line I get this:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
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)
I'm running Slackware 13 - xfce4 and I got a new session in background. How could I see that session and use it? In backtrack I'm doing it via sessions in terminal but im Slackware 13 session command doesn't exist.
View 2 Replies View RelatedIs there a way to send a terminal command to an already opened xterm terminal
View 4 Replies View RelatedI've two internet based server ( xx.xx.xx.xx and yy.yy.yy.yy ) The Y server is running VNC server and is responsible for answering to VNC sessions. But I need to hide the IP of Y server so I want X server to be as VNC Proxy and redirect all VNC sessions to Y server.
I guess the best way is to use iptables but actually I can't get it working so
I am using gtk to program GUI. How can I show the output of shell command into a textbox, ex ps -efc command ?
View 3 Replies View RelatedI have an issue with my web server. We are running RedHat Enterprise Linux 3.0 with Apache 2.0 and Tomcat 5.5. The situation has arisen that the httpd sessions never terminate. New connections continue and continue to be created and never die. I have restarted the apache services to reset the connection and have even rebooted the server, however, to no avail. Yes, that does the trick of getting the web sites operational, however, this is not a solution.
I have searched and searched here, www.google.com/linux to no avail. I have looked through the apache.org bug tracker and can't find anything like what I am experiencing. This happened 6 months ago and I got lucky and it stopped, however, the situation has resurfaced. I have reviewed the logs and found nothing that provides any insight.
During the business day, the number of httpd connections continue to grow and I decided to let it see how high it would get before the web sites would crash. That magical number is 203. Now that it is later in the evening and about 2 hours since I restarted the httpd services, I now only have 59 connections. However, I'm fairly certain based upon the traffic on these 2 websites, that in the evening, there aren't many connections after 2000 hours.