I want to use MYSQL administrator remotely, if I try I just get Host 192.168.1.216 is not allowed to connect to this mysql server. All the fixes I see on the Internet are for specific databases, but I want to access everything?
View 5 RepliesI 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 want to setup my MySQL database and have MySQL up and running. I sill look for a good editor to add and configure my tables, it appears that MySQL Administrator is the only GUI client available.
But when I try to add a foreign key to one of my tables, there appears to be a problem. Both of my tables are InnoDB and both have a primary key.
-First I choose the tab "Foreign Keys" on my CLIENT table.
-Then I press the green + sign to add a foreign key, it is default named new_fk_constraint.
-I choose my table USER in the Refer.Table dropdownbox
-And then I should be able to match the FK field and the PK field in the box on the right... but this box is empty. Double clicking shows nothing. I only can drag the user_id of the USER table to it, but have no option to select the foreign column.
What the hell is wrong here??? This client is years old and should be really REALLY working IMHO! I was told by a friend that there is no good client available and therefore he is using some Windows program for this...
what is wrong with this SQL to create a stored procedure in MySQL please?
Code:
CREATE DEFINER=`root`@`localhost` PROCEDURE `CheckStatus`(
IN start_date DATE,
IN end_date DATE)
BEGIN
[code]...
To me the syntax is correct. It complains with error 1327 'Undeclared variable: temp_sales'. What I don't understand is why I would need to declare a temporary table's name as a variable. Am I missing something here?
One server is a dedicated MySQL server. After upgrading that one to Ubuntu 10.04 (from an ancient Suse 9.2), both servers are running Ubuntu 10.04 LTS.I have another server that I use to administer the database server via phpMyAdmin. However since the upgrade it is not able to connect. I get an error #1130 Cannot log in to the MySQL server. The same happens if I try to connect remotely from the command line with: mysql -u root -h 129.79.137.121 -pI'm not sure if this is an iptables/ports problem or a configuration problem on the MySQL end or something else entirely.I've searched and tried the suggestions I've found in various places but none seems to have fixed it.
View 2 Replies View RelatedI have an application running on a centOS machine that needs to access a database on a CentOS server. I granted access to all users with a certain user name and password.i opened up port 3306 as well with the following command: /sbin/iptables -A INPUT -i eth0 -p tcp --destination-port 3306 -j ACCEPTbut whenever i try to connect from my machine i get an error:ERROR 2003 (HY000): Can't connect to MySQL server on '172.16.102.129' (113)I am using mysql version 5.0.77 on centOS 5.5.
View 1 Replies View RelatedI'm new to linux, and setting up the mysql database server.
Here are my situation:
OS: CentOS 6
mysql version: 5.5
I tried to use MySQL Administrator to connect to my database on the host 192.168.1.120
and my computer is under the same network with ip: 192.168.1.105
But it shows the error msg: Could not connect to MySQL instance at 192.168.1.120
Error: Can't connect to MySQL server on '192.168.1.120'(61)(code 2003)
On the server side I've tried:
Code:
skip_networking is off and I've set the port for it.
When I check the process in OS:
Code:
When I try netstat:
Code:
I thought it's the problem of firewall, so I have check it also:
Code:
While reading some papers on securing apache with selinux, I have tried to bind httpd to port 3000 expecting to be blocked by the selinux, since port tcp 3000 isn't on the http_port_t list. However I was able to start the service...
I'm preety sure selinux is enforcing. Also, if I bind httpd to tcp 81 selinux denies the start of the service, as expected!Did I miss something? Why is httpd allowed to start binded to a port that's not explicitly allowed?
What commands can be used to install software such as "phpMyAdmin" to Fedora? As I am setting up Apache in Fedora. How to install "phpMyAdmin" and setup phpMyAdmin, so that I can use internet explorer to manage the phpMyAdmin to configure the MySQL database remotely.
View 2 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 RelatedDoes anyone know or recommend some software or a script to remotely power on a PC from standby to on, or even better from completely off?
I guess the completely OFF to ON is much more complicated - would probably require an extra piece of hardware(?)
I'm not terribly new to Linux, but I am new to the forums, so hear me out! I am in the process of creating an electronic mapwall for our meteorology program, and have designed the computing system from scratch. I have two Linux Boxes, each with capabilities for 6 attached monitors...a total of 12 displays driven from two machines. My intention is to have one machine be the master...it has a touchpanel control. The inputs to the touchpanel will then trigger events for the both the master and the slave machine to display. Each of them has a specific IP address (DNS entry), and are not on a subnet.
Now...is there a way to remotely login to the slave machine and have it display on it's OWN monitors? The code is Java and which works on the master machine to animate directories of .gifs for each of the master's attached monitors. I will most likely have Java execute shell commands for the remote login (ssh), but I believe the answer lies somewhere in the X-configuration. Do I have the machines in an adverse configuration (creation of a subnet would be better)? Lots of questions...lots of desire...few answers!
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 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.
how will i login as administrator in ubuntu?
View 2 Replies View RelatedI finished my Bachelor's degree in Electronics and communication engineering in 2007. I finished RHCE in 12th July 2010. I don't have any work experience in the field of linux. Previously i had been working in knowledge processioning outsourcing which is completely not related to the field of linux. I have no experience in the field of linux. I have also finished CCNA in 2008. I have no experience to what I have studied. Can I get a job as a linux administrator? If I want to get a job what are the necessary things should i do?
View 10 Replies View RelatedI am using VMware to install RHEL 5.0 through an .ISO image in my lappy, bcoz my DVD-ROM is not working.While installation it didn't ask anything except user-name and password and it got installed correctly.But the problem is that, when I open a terminal it always opens in USER mode ($- prompt) and working directory shows(/home/user).how can I use the administrator(/root) ---> # -prompt.
View 5 Replies View Relatedeverytime I try to enter any of the admin controls ie update manager etc the window opens for a split second then crashes also if the sound is turned up or down via keyboard shortcut the sound bar starts flashing very fast and the keyboard becomes inoperative, I have tried rebooting etc with no avail, I have done everything that I can with my very ltd knowledge, this first started after the last update I am using 9:10 KK.
View 5 Replies View RelatedI recently installed lucid on my new laptop (Thinkpad T410, since had some problems installing Karmic). Originally ran great, yet after several days lost the ability to log on as administrator using the login screen. After several seconds, it just sends me right back to the same screen. However, at the same time, I have no problem logging on as a different user via this screen. I'm also able to login no problem using the command line. I can toggle between this command screen and the visual user account, so can run what I need in root and then transfer to the user account so I can view it.
View 3 Replies View RelatedCertain commands like:
fdisk -l
nmap -sT 192.168.0.1/24
iftop
require administrator privileges to run. A while ago i read a post(forgot where i read it) about being able to let a user run these commands in a script (that contains the desired command) created by the administrator/root without the user having to do a sudo and entering a password. Does anyone know how i can go about doing this?
When i istalled kde4 on ubuntu 10.04 and login that this erro show me: p, li { white-space: pre-wrap; } Configuration file "/home/bahram/.kde/share/config/klipperrc" not writable. Please contact your system administrator.
View 1 Replies View RelatedI am only user on this ubuntu 10.10 install. I have admin rights but when I try to change some settings via Ubuntu tweak unlock or alter user and groups via advanced tab I never get the option to enter my password. I have added a new user 'tempuser' via safe mode and this user is administrator too but everything works fine from this user..
Results from $ grep admin /etc/group
lpadmin:105:heath,tempuser
admin:119:firstuser,tempuser,heath
Results from groups
admin adm dialout fax cdrom floppy tape audio dip video plugdev fuse lpadmin sambashare
I am thinking of making a fresh install if I cant sort this but would like to fix if possible.
Strange. After a recent update, I can no longer right click on a folder and open it as Administrator. I get this error message:
Unable to determine the program to run.
The item you selected cannot be open with administrator powers because the correct application cannot be determined.
I don't quite get this but why is it looking for a program to run? I only want to open a folder, not run a program. Anyway, I have done an uninstall and re-install of nautilus-gksu but that did not solve the problem. I have googled but no answers I could use.
Again, all I want to do is open a folder as Administrator so I can perform other operations that require root permission on files in that folder.
using: 10.04 LTS fully updated
Is possible install wubi-ubuntu in other folder? or in the same way how can I run ubuntu in windows without administrator permission?
View 1 Replies View RelatedI was wondering if there was an option like what windows has, where, while in explorer, you can right-click a file, choose "Run as Administrator...", enter your password in the dialog box, and open the program with admin privileges. Is there a script out there for linux to do this? If so, where is it, and how can i install it?
View 2 Replies View RelatedI am trying to run eclipse with administrator rights so that it can access any folder on my system.
View 9 Replies View RelatedI just noticed that even if I remove read and write permission for my files, another user can access those files if they use 'sudo'. The ls -l for the folder containing my file (let's call is myfile') looks like this.
"
Code:
-rw------- 1 username groupname 43 2010-03-09 20:23 myfile
"
I logged into another account I have made for myself (which had admin privileges) and then did
Code:
sudo nano /username/home/myfile
and ... the file was opened and I was able to read it. So what's the point of having user permissions if someone can bypass them by using sudo?
I just got a fresh Ubuntu 10.04 install on a system, added Lubuntu (the poor thing's 10 years old), and added a second user and gave him sudo/admin rights via the Users and Groups app. All was working fine, but now the initial user can't make any system changes. The initial user can still execute sudo and gksudo, but not much else.
In the Network Connections applet, the initial user can't edit the "Auto eth0" connection, the "Edit" and "Delete" buttons are just greyed out.
In User and Groups, I can click "Advanced Settings" or "Change" on another user, but nothing will happen. If I click "Add User" as the initial user, it will give the "Not authorized" popup.
I had a second user that I'd given adminstrator/sudo access to. So to change the network settings I logged in as this user for the first time, and was able to change some things. However, after a reboot I had the same problems with this new account.
I haven't done anything with this install besides install openssh-server, add some firewall rules with ufw, and add the Lubuntu desktop. Most of my google results turned up basic stuff like corrupted sudoers file (mine is still in pristine, default condition), and not being part of the admin group (which both users still are). The behavior also persists regardless of whether I use gnome or Lubuntu for my session.
On my 10.04 desktop i have some maps from a user that doesn't exist anymore, but I can't do anything with it. Is there a possibility to make a "open as sudo" or something like that in the mouse menu? I haven't found an other way to do something with these maps
View 1 Replies View RelatedThere where some updates for 10.04.1 yesterday, after I installed them, a few hours later I restarted my machine as new headers and kernel files where downloaded.So this morning, when I come in, I wanted to check my software sources as I saw something a little odd yesterday.When I try to start that program; I am asked for my administrator password. Not the password I use for administrative tasks; which is what I am generally asked for.Anyone else seeing this? And if so, what happened. The admin account I have setup is My account, I am the only person on the machine. In the past I have entered my password and carried on; not this morning. Not sure what is happening; but I have not setup an actual admin account / password.
View 4 Replies View Related