Ubuntu Servers :: Mysql Only Allowing Connections From Localhost
May 11, 2010Howcome mysql by default is only allowing connections from localhost? I want to access it remotely from another account (not root).
View 1 Replies
ADVERTISEMENT
Ubuntu Servers :: Allowing Connections From The Outside World Through SSH?
Jan 9, 2010I want to set up my laptop to allow connections to certain users with passwords from anywhere over the internet via SSH but I'm unsure about how I would go about doing this. I only thought it would be the case of setting up the open-ssh server on the laptop then, using my external IP and PuTTY on another PC outside of the network, connect to the external IP through port 22 so I tried this and wait 3 or 4 minutes or so and it says the connection times out.
I have also configured my router to use port forwarding but this doesn't seem to help much either and I have LAMP setup to allow connections to external IP : 80. The only thing I am able to do is access the laptop through the local network by using its internal IP's like 127.198.0.1:22 or something. I was wondering if anybody knows if and could tell me how I would do this as I really want to be able to access my home computer/laptop from my work sometimes, especially if I have work at home which is not with me at work or something.
I know this is possible but I'm quite new to this type of thing and don't know what is going wrong. Have I missed something or do I need to change any .conf files or anything?
Ubuntu Servers :: Setup The MYSQL Server - Error: 'Access Denied For User 'root'@'localhost' (using Password: NO)'
Mar 26, 2010I set up a servber on my local machine, & also PHp - Both working fine.I'm trying to load up MYSQL i have installed it, & *can* start/stop the server. however if I do anything else with it, I get this error :-
Quote:
root@gordon-desktop:~# sudo mysqladmin -u root -h localhost password MYPASSWORD
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'
Query :-
1) How do I know MYSQL is actually active ? (apart from the message it says that its statrted (or stopped).
2) Is there a way to
a) Find out the usernames that are recorded on the MYSQL server ?
b) set / RESET the 'root' username (I know MYSQL root user is different to PC root user)
c) anything else I can do on the PHP / website code to see if MYSQL is working
(as yet, no tables / databases etc have been set up - as I can't get past this error message - I get the same error when setting up a database.)
Ps I did allow my usermname (when logged in to ubuntu) to edit / create files in the /usr/www/ directory (but it is still OWNED by 'root' - that directory)
Ubuntu :: Allowing Incoming Connections On Port 22 From Anywhere?
Jul 19, 2011I'm trying to get VNC working but I'm getting this error message:
Quote:
ssh: connect to host my_ip_address port 22: Connection refused
When typing:
Quote:
ssh -f -L 5900:localhost:5900 user@my_ip_address x11vnc -safer -localhost -nopw -once -display :0 && sleep 5 && vncviewer localhost:0
I'm trying to follow the instructions here: [URL] but I'm struggling with point 2 & 3:
Quote:
2. If you have previously reconfigured the firewall on your PC, make sure the firewall allows incoming connections on port 22 from anywhere, and on port 5900 from localhost (also known as 127.0.0.1)
3. If your PC is behind a home router, or any other device that uses NAT, configure your router to send connection attempts on port 22 (but not port 5900) to your PC
So my questions are:
1. I installed a fresh version of Ubuntu 11.4, should I be concerned about step 2? If so, how can I allow incoming connections on port 22 from anywhere, and on port 5900 from localhost?
2. Regarding step 3, I'm using NETGEAR model DGN1000 router. Is that something that I should do from the router's setting page or it's some commands that I should pass through SSH?
General :: Allowing VNC Connections Into Mint?
Aug 26, 2010Do any programs need to be installed that aren't included in the default install of Linux Mint in order for it to allow VNC connections?
View 3 Replies View RelatedGeneral :: Fedora 10 Stops Allowing Connections?
Jun 3, 2010I have Fedora 10 set up as a server. Occasionally it will stop allowing connections, such as ssh, http, and samba. This continues until someone hits a key on the keyboard, and then it seems to come back to life and accept connections. At this point, the date and time will be wrong. Judging from monit messages that inform me when it stops allowing connections, I think the time freezes at whatever time it is when it stops allowing said connections.
Power Management has it set for the computer to never turn off. Sleep mode is also disabled in the BIOS.
I thought it was possibly the CMOS battery, but that has been replaced and the issue persists.
Someone previously thought it might have been Network Manager, but that is disabled due to issues it has with a static IP.
Ubuntu Installation :: 11.04: Remote Desktop Only Allows Connections As 'localhost'
May 3, 2011Under 10.10 the settings dialogue for Remote Desktop said that other machines can connect to this one as kubuntu.local or 192.168.1.85 but after u/g to 11.04 instead of hostname or IP it now just says 'localhost' - which won't work for obvious reasons. I use RD a lot.
Also, despite 'Always display an icon' being checked no icon is displayed in the panel. I tried checking 'Never display an icon' closing the dialogue, re-opening it and re-selecting 'Always display' it still doesn't appear.
CentOS 5 :: Tftpd Only Accepting Connections From Localhost?
Jul 12, 2011Having a problem with tftpd on CentOS 5.5. I am only able to download files from the localhost address.
I have checked iptables (by adding rules and by turning the firewall completely off -- nothing changes) and enabled tftpd logging (by adding -v to the server_args section in xinetd.d/tftp) and I DO see the request coming in, but no response from the daemon. I've also tried upping the verbosity by adding multiple -vs and/or --verbosity 10 to the mix, but all I ever see is the initial request come in, nothing more. I've even tried running the daemon in foreground mode with -L but I get no verbosity then.
Ubuntu :: Can't Run MySql Localhost And Apache
Dec 23, 2010if I should ask this in the server section. But since I use the desktop version of Ubuntu I will ask here. Basically my server is going on pension. Hardware is outdated and all that. Since it's main job was serving me with MySql databases with web interfaces I sommer want to shift all of that over to my desktop and run my databases on the desktop. It's only me that access it so don't see why I can't run it localhost.
My question is. The three main things I need, apache, Mysql and php, are they in the repositories in Synaptec ? If not how hard will the install and config of those three apps be on Ubuntu Desktop? (I've always used Fedora as server with everything build-in so have no experience of installing mysql, apache and php from scratch)
Server :: Cant Connect To MYSQL On Localhost
May 28, 2011Running MYSQL 5.5.12 and MYSQL Workbench 1:5.2.34 on up-to-date Arch linux Set up MYSQL with root account and password. When running Workbench as user, got error when trying to connect :
Quote:
Cannot Connect to Database Server Your connection attempt failed for user 'root' from your host to server at 127.0.0.1:3306: Can't connect to MySQL server on '127.0.0.1' (111)
1 Check that mysql is running on server 127.0.0.1
2 Check that mysql is running on port 3306 (note: 3306 is the default, but this can be changed)
3 Check the root has rights to connect to 127.0.0.1 from your address (mysql rights define what clients can connect to the server and from which machines)
4 Make sure you are both providing a password if needed and using the correct password for 127.0.0.1 connecting from the host address you're connecting from
After commenting #skip-networking in my.cnf error changed to :
Quote:
Cannot Connect to Database Server Your connection attempt failed for user 'root' from your host to server at 127.0.0.1:3306: Lost connection to MySQL server at 'reading initial communication packet', system error: 0
1 Check that mysql is running on server 127.0.0.1
2 Check that mysql is running on port 3306 (note: 3306 is the default, but this can be changed)
3 Check the root has rights to connect to 127.0.0.1 from your address (mysql rights define what clients can connect to the server and from which machines)
4 Make sure you are both providing a password if needed and using the correct password for 127.0.0.1 connecting from the host address you're connecting from
Copying my.cnf to /etc/ and running Workbench as root didn't change anything, i still get the second error The wiki [URl] says to enable MYSQL in /etc/hosts.allow but i didn't do it, i guess it is required only when trying to access MYSQL from remote hosts which i dont.
Server :: Unable To Connect Localhost In Mysql
Apr 21, 2011iam not able to connect localhost in mysql.i uswd command for mysql is
#mysqladmin -u root -h localhost password "123456"
ErroR:-
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'
Server :: Why The Php Mysql_connect() Only Can Connect Localhost MySQL
Apr 17, 2011I used 4 host to establish a high-availability web server system. 2 Load Balancer + 2 Web Server(installed MySQL Server 5.5). 2 MySQL Server used Multi-Master Replication.Used "Amoeba" as MySQL Proxy which direct the write statement to a specific MySQL Server.I can login Amoeba and MySQL Server using MySQL client. I tried query something in XAMMP on Windows XP. It work!
Installed related software:
MySQL-server-5.5.11-1.rhel5
MySQL-shared-compat-5.5.11-1.rhel5
php53-mysql-5.3.3-1.el5_6.1
MySQL-client-5.5.11-1.rhel5
[code]....
What I tried:
yum install php php-mysql
yum install php53 php53-mysql
Compiled php 5.3.6 soruce + MySQL 5.5 Server, Client, Shared, Shared-Compact Above software installed on different host. And the phpinfo showing MySQL I doubt something wrong in my php.ini. Used default php configuration.
CentOS 5 Server :: Php Can't Connect Mysql By 'localhost'?
Sep 25, 2009php can't connect mysql by 'localhost' but can connect by IP address:
[Code]...
Ubuntu Servers :: Snmp Not Allowing Outside Query
Aug 11, 2010our 9.x servers are running perfect. Just setup 5 new webservers, running 10.04LTS. Have SNMPD running, installed and the same config for all the servers I just copied over, by config, I mean one line, that's it. So the servers have the following /etc/snmp/snmpd.conf file rocommunity public
That's it. Now the only difference is looking at the ps on the local box's, a working one shows;
snmp 1096 0.0 0.0 50480 3756 ? S Jul02 9:21 /usr/sbin/snmpd -Lsd -Lf /dev/null -u snmp -I -smux -p /var/run/snmpd.pid
where this one shows
snmp 4962 0.3 0.0 48540 5884 ? S 22:26 0:04 /usr/sbin/snmpd -Lsd -Lf /dev/null -u snmp -g snmp -I -smux -p /var/run/snmpd.pid 127.0.0.1
Notice (I did flag it red) the local 127.0.0.1, but that co-incides with my
[Code]....
It almost seems something firewall is blocking, apparmor is not running, is there something else out of the box 10.04 has that I am just completly brain farting on?
Server :: Changed Root User Access For MySQL To Any From Localhost?
Mar 14, 2011I did something silly and changed my root user access for mysql access to Any from localhost using webmin. I get an access dented when i try to open up the mysql editing page on webmin. Can any of you tell me if there is a way to change it back to hosts=localhost I am using webmin 1.5.30 on Centos 5.5. I am hoping I can change it by command line or if I can access the config files and change it that way?
View 2 Replies View RelatedUbuntu Networking :: QBittorent With Portforwarding 6881 - Router And Run Nmap On Localhost "no Direct Connections"
Mar 16, 2011is there still a bug in qBittorent with portforwarding 6881? i forwarded it in my router and run nmap on localhost and shows its open yet it is always saying no direct connections on the bottom with that little yellow globe near the nodes
[Code]....
Ubuntu Servers :: Allowing FTP Access To External HD Connected To PC?
Apr 19, 2010I have proftpd setup on my Aspire Revo (which I'm using as an HTPC) so that I can download files to my mac when I feel like watching in bed or whatever. I recently purchased a 1TB WD Elements to store my media. I have proftpd setup so that I can access every file on the computer. However, when I try to gain access to the Elements HD, I get an FTP error from Cyberduck that says:
/media/Elements: no such file or directory
Note that I have not formatted the drive or anything - just set it up straight out of the box. My media is loaded on to it, and XBMC reads the files fine. Is there a way I can enable the hard drive (or the OS) to share these files over FTP, or is this not possible?
Server :: Mysqladmin - Connect To 'localhost' Failed(Confusion Abot MySQL And Mysqladm?
Mar 10, 2010I have some confusion about mysqladmin and mysql.I am using mysql version Quote:
[root@localhost freepbx-2.7.0]# mysql --version
mysql Ver 14.12 Distrib 5.0.77, for redhat-linux-gnu (i686) using readline 5.1
My MySQL is running
Quote:
[root@localhost freepbx-2.7.0]# /etc/init.d/mysqld status
mysqld (pid 11440) is running...
[Code]...
Ubuntu Servers :: Mysql Error Stopping MySQL Database Server Mysqld?
Jun 17, 2010I 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.
Ubuntu Servers :: Mysql ERROR 1045 \ Trying To Allow Remote Access To Mysql?
Jan 14, 2011i 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]....
Red Hat / Fedora :: Will Adding ODBC Affect Mysql Connections
Apr 19, 2011I have cpanel running and working with mysql. I need to add ODBC so I can get server side action script to connect to mysql also. Will adding ODBC affect anything else? I don't want to affect the way anything else connects?
View 1 Replies View RelatedSoftware :: ERROR 1040 (00000): Too Many Connections In Mysql
Apr 25, 2011I am maintain one site recently i have kept login form and registration pages on my at that time the site was opened. But the within 2 to 3 days after i got below error
#####################################
ERROR 1040 (00000): Too many connections in mysql
#####################################
mysql version 5.0.45
how to solve i thing my mysql database not supported for more members how many users able to connect to my database.
OpenSUSE Network :: ERROR 1044 (42000): Access Denied For User ''@'localhost' To Database 'mysql'
Nov 9, 2010I think I screwed up my Administrative username in mysql.
mysql -u root mysql
ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'mysql'
Can I just copy all the files in /var/lib/mysql >>reinstall MySQL >> copy all the old folders into the new /var/lib/mysql ( while MySql is off)
Fedora Servers :: /var/www/html - Not Allowing To Do Any Changes/create The Files Or Folders
Aug 8, 2011I m able to do the changes in the home directory of the users' but when it comes to the /var/www/html folder, it's not allowing to do any changes/create the files or folders
I m able to view the files and it's contents
Global Settings:
Programming :: MySql [Centos] - ERROR 1040 (00000): Too Many Connections
Apr 18, 2011I execute: mysql -u root -p and asks for a password after I put the password and ENTER the following error! ERROR 1040 (00000): Too many connections Can you tell me where is the folder of mysql? For me to edit the my.cnf?
View 12 Replies View RelatedUbuntu :: 2 Pptp Vpn Connections - When I Dial One Of My Vpn Connections, My Other Vpn Connections Be Disabled?
Feb 7, 2011have a problem with my network-manager in ubuntu 10.10.when I dial one of my vpn connections, my other vpn connections be disabled and I can't use them!I tried to restart network-manager and gnome-panel, but it does't seem to solve this problem.
View 1 Replies View RelatedUbuntu Servers :: Telnet Localhost 110 Says Trying ::1?
Aug 14, 2010I am trying to set up postfix on my ubuntu server.When I try to login to the pop accounts through telnet
Code:
user@ubuntu1:/$ telnet localhost 110
Trying ::1...
[code]....
Ubuntu Servers :: PHP IRC Bot, Not Connecting To Localhost?
Jun 3, 2011For some rather odd reason, my IRC bot wont connect to the local irc server, but it will connect to IRC.FREENODE.NET, I have no idea why...
PHP Code:
<?php/** PHPIRC Class Simple IRC Bot * * @author Ferdinand E. Silva
[code]...
Ubuntu Servers :: Bind Phpmyadmin To Localhost Only?
Mar 18, 2010Have basic LAMP setup on 9.10 box. I want to have a publicly accessible website AND I want to have phpmyadmin available. The only thing is I would rather not have the phpmyadmin interface available on the internet. I usually open a ssh port forwarded tunnel when I need to use phpmyadmin on this server. I want to add a directive to make phpmyadmin bind only on localhost. I have found the phpmyadmin config file in /etc/apache2/conf.d
phpmyadmin.conf -> ../../phpmyadmin/apache.conf
I have tried adding some LISTEN directives, but apache does not like my directives-- I am obviously not doing it right. I have looked for a bit on the internet and can't find out how to disable external access to a configured site in Apache.
Ubuntu Servers :: No Frontpage Is Displayed At Localhost?
Sep 6, 2010Instead of XAMPP or LAMP, I installed a local web server to my Ubuntu 10.04. Apache and phpmyadmin works well.
I copied the files of my Joomla website to /var/www folder. When I go to administrator panel, it works. But when I type in the browser "http://localhost/[folder_name], a blank page appears and nothing else.