Red Hat / Fedora :: Enabling Mysql In Server (port 3306) It Doesn't Work?
Apr 12, 2011when i am enabling mysql in server (port 3306) it does'nt work. but when i execute iptables -F it works what may be the reson?
View 6 Replies
ADVERTISEMENT
CentOS 5 Server :: Changing Default Mysql Port As 80 From 3306
Feb 2, 2009I want to change my MySQL default port(3306) as 80 how can i do this on centOS 5.2? I tired to add
[client]
port=80
to /etc/my.cnf and different command in this file. But mysql didn't start. How can do this? I'll use server only as mysql and ftp server.
Server :: Mysql In Redhat Two Machine Cluster Not Opening 3306 Port?
Jul 18, 2011Im having a frustrating issue with my two machine cluster I setup using Conga. Everything was working great except now when lucci starts mysql the port (3306) is never opened to outside machines. I can do a "ps -ef | grep mysql" and see it running as well as login to mysql on the node it is running on - but an nmap of the machine does not show the 3306 port and I cannot login to mysql remotely and yes I turned off all iptables(iptables,ip6tables) and SElinux is disabled.What am I missing here? If I start mysql on my own (and it is using the same my.cnf as lucci is) it does show the port open and works perfect,t for some reason when lucci starts it, no dice
View 1 Replies View RelatedDebian Configuration :: Mysql Port 3306 Not Visible?
Sep 3, 2010Everything default.Everything works nicely with one exception. I can't connect to MySQL from the network.nmapping localhost tells me 3306 is open but nmap from the outside shows only ports 22 and 111 open. To my knowledge I have no firewall, iptables -L gives an empty set.I have several similar installations on the same network without any problems of this nature.
View 2 Replies View RelatedUbuntu Networking :: Cannot Connect To MySQL (3306 Port)?
Jan 14, 2010How do I get mysql 3306 port to be seen on my network?
Here is my setup:
---Desttop - WIndows Vista Ultimate (192.168.0.101)
--------VBox
------------Guest - Ubuntu 9.10 (Joomla CMS Development) (192.168.56.106)
---Server - Ubuntu 9.10 (192.168.0.100)
--------VBox
------------Guest - Ubuntu 9.10 (Joomla Production) (192.168.56.104)
------------Guest - Ubuntu 9.10 (MySql Database) (192.168.56.105)
I can ping all OS from any OS, I can connect to a shares, I can connect to the web server. I can do a netscan and display the open ports and the services for those ports except for MySql. How do get MySql to showup, so I can connect to it from my Joomla CMS? I came from openSuse and I like how they have modules to do this automatically. What do I use with Ubuntu to get the same results?
Ubuntu Networking :: Unable To Open Port 3306 For MySql
Jul 18, 2010I've been working and researching this for about a week now and I still haven't had any luck. Basically, I have been trying to open port 3306 to allow connections to my MySql server.
i've added the rule into iptables, saved and restarted that i've added the rule into my router. and I have removed "skip-networking" from the my.cnf file and added the blind address in, I'm trying to get this all to work on my LAN, but it doesn't seem to work, I've also restarted the entire server and then port scanned it from outside and inside the networking and it still tells me that 3306 is closed.
I did however i had some luck when I entered the Ip of the machine that would be sending data to the server but then PROFTPD stopped working and the port was open :/ im not really sure what ip should be in there but another thread from another forum said to enter the ip of the machine that mysql is installed on.
so currently its 192.168.0.2 which is the static internal address of the server.
every machine on the network has a static ip and all the rules have been added to each firewall, i.e. server and router firewalls.
ill pop my "my.cnf" under this to see if anyone can find a mistake,
Code:
# This will be passed to all mysql clients
# It has been reported that passwords should be enclosed with ticks/quotes
# escpecially if they contain "#" chars...
# Remember to edit /etc/mysql/debian.cnf when changing the socket location.
[Code].....
General :: Connecting To Mysql Database Remotely Via Port 3306 ?
Jul 23, 2011I'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:
Ubuntu Networking :: Make 127.0.0.1:3306 Redirect To A Remote Mysql Server?
Mar 22, 2010I'd love a hint or two on the following problem. I've set up iptables rules to forward all connections to port 3306 to a non-standard mysql port on a remote server. This works, except that I need to deal with the loopback interface in a special way and I'm stuck.
Code:
iptables -t nat -A PREROUTING -p tcp --dport 3306 -j DNAT --to 128.XXX.XXX.XXX:3197
iptables -A FORWARD -p tcp -d 128.XXX.XXX.XXX --dport 3197 -j ACCEPT
iptables -t nat -A POSTROUTING -j MASQUERADE
Since locally-generated packets will never hit the PREROUTING rule, you'll need to setup a near identical rule using OUTPUT to make it work. Here is what I've tried:
[Code]...
General :: How To Check Port 3306
Mar 10, 2010How do I check port 3306 to see if it is being used? I am unable to get MySQL to run with a LAMPP 1.7.3a installedon Ubuntu 9.10. The Apache server and ProFTPD start fine.
View 2 Replies View RelatedServer :: Mysql 'Table 'mysql.user' Doesn't Exist'?
Aug 2, 2010I'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]...
Hardware :: 10.04, USB 3.0 Port Fresco FL1000G Doesn't Work?
Feb 2, 2011i have a mainboard asrock 880gmh/usb 3.0 with ubuntu 10.04 but the usb 3.0 port doesnt' work.
MY PC:
Distributition: *ubuntu
version: 10.04
Desktop environment: GNOME
Info: CPU: Amd Athlon II X4 645 3.10 GHZ Socket AM3
RAM: 4 Gbyte DDR3 1600 Mhz HD: 2 Western Digital Sata 500GB 32MB WD5000AADS
Video Card: Ati HD 4250
[Code]...
Ubuntu Installation :: Ndiswrapper - Ethernet Port Doesn't Work
Jul 27, 2010installing ndiswrapper. I've used Windows all my life and I just made the jump to Ubuntu a couple days ago, install native drivers for my card, but at the end of the list of like 25 packages there are 4 packages that won't install because they all say they have dependencies upon each other. Now, I'm trying ndiswrapper and I don't understand it in the least little bit... I know I'm an utter noob, but the OS seems amazing, I'd just like to connect to the internet with it. Even the ethernet port doesn't work! :/
View 1 Replies View RelatedUbuntu :: Powerbook G4 Wifi Driver, Ethernet Port Doesn't Work
Sep 21, 2010I just installed Ubuntu 10.04 on my Powerbook G4 1.5ghz 15", and the ethernet port on the laptop doesn't work. So I can't search for drivers to install.
Is there a way to either tether internet to the laptop using firewire? find the necessary drivers so I can transfer them?
Server :: MySQL Move Database / Server Doesn't Start
Nov 3, 2010I'm trying to move a mysql 5.1.50-community InnoDB database from one location to another.When starting the service I get:Starting MySQL.Manager of pid-file quit without updating file [FAILED]I've searched for a way to do this but I can only find people who describe what I've just done.
View 6 Replies View RelatedGeneral :: USB Port Nn Disabled By Hub (EMI?), Re-enabling
Oct 31, 2010getting this occasionally in dmesg USB port nn disabled by hub (EMI?),re-enabling and I would like to know: What does the message mean, exactly? What is the actual hardware error code from the USB subsystem? Under what conditions would the root hub disable the port?Is it related to the USB power or the USB data lines? If it's power, what aspects of the USB power does the root hub monitor? Voltage out of limits? Current spike? Ground bounce?Can this power monitoring feature be turned off in the Linux driver settings?
View 2 Replies View RelatedSoftware :: Cannot Close Port 80 On PC By Enabling Firewall (UFW)
Oct 16, 2009Jst to tryout ufw I tried to close port 80 on my pc. I'm using Ubunutu 9.04. I sudo ufw enable sudo ufw deny 80. But nmap localhost shows port 80 open why? How can I close it? I will need to control some ports on my next server.
View 2 Replies View RelatedFedora :: MYSQL Error 2002 (HY000): Can't Connect To Local MySQL Server Through Socket?
Feb 22, 2011I'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
CentOS 5 :: Enabling MySQL Archive Engine Without Compiling From Source?
Aug 19, 2010Is there a startup option I can put in the /etc/init.d/mysqld script or an option in the /etc/my.cnf file to enable the Archive engine for MySQL or do I have to compile it from the source?
[Code]....
Debian Configuration :: MySQL Server Doesn't Start
Jun 18, 2015Since upgrading from Wheezy to Jessie I have not been able to start the MySQL-server. When I do a "systemctl start mysql" I get the following answer on the console:
Job for mysql.service failed. See 'systemctl status mysql.service' and 'journalctl -xn' for details.
Entering 'systemctl status mysql.service' the answer is:
● mysql.service - LSB: Start and stop the mysql database server daemon
Loaded: loaded (/etc/init.d/mysql)
Active: failed (Result: exit-code) since Don 2015-06-18 18:35:41 CEST; 4min 1s ago
Process: 11272 ExecStart=/etc/init.d/mysql start (code=exited, status=1/FAILURE)
syslog and hostname.err don't show any pertinent messages.
Server :: Mysql MyISAM Table Doesn't Have .MYD And MYI Files
Jan 26, 2011We have a MyISAM table without .MYD and .MYI files for storing data and index but we can select data from the table. We can't use mysqlhotcopy for backup the table. Each time,we execute mysqlhotcopy, we have the following error: 'dbs.table: is not base table'. How do we repair the table to re-create .MYD and .MYI files?
View 2 Replies View RelatedServer :: Getting MySQL To Work With SSL?
Mar 3, 2010I have installed the MySQL server on two machines and got them to work as master - master over the internet. But since this is not very safe I wanted to get them to work over SSL. I first setup one machine and that worked. However, after setting the second machine to work over SSL it all stopped. I have checked many howto and faq documents without success.
It seems to be related to the certificate I think. This is a dump from the /var/log/syslog file for MySQL:
Mar 3 17:33:02 asterix mysqld: SSL error: Unable to get certificate from '/etc/mysql/mysqlcerts/remoteMaster/client-cert.pem'
Mar 3 17:33:02 asterix kernel: [ 7209.109831] type=1503 audit(1267633982.018:274): operation="open" pid=1324 parent=1071 profile="/usr/sbin/mysqld" requested_mask="r::" denied_mask="r::" fsuid=102 ouid=102 name="/etc/mysql/mysqlcerts/remoteMaster/ca-cert.pem"
Mar 3 17:33:02 asterix kernel: [ 7209.109877] type=1503 audit(1267633982.018:275): operation="open" pid=1324 parent=1071 profile="/usr/sbin/mysqld" requested_mask="r::" denied_mask="r::" fsuid=102 ouid=102 name="/etc/mysql/mysqlcerts/remoteMaster/client-cert.pem"
This is repeated many times...
I have copied the certificate files in a folder that is owned by mysql:mysql so I assumed that this would be ok.
OpenSUSE Network :: ERROR 2002 (HY000): Can't Connect To Local MySQL Server Through Socket '/var/mysql/mysql.sock
Jun 7, 2011I 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]...
General :: "Lost Connection To MySQL Server" When Using Different Port?
Apr 28, 2011I'm getting the following error on my webpage :Warning: mysql_connect() [function.mysql-connect]: Lost connection to MySQL server at 'reading initial communication packet', system error: 111 in /var/www/vhosts/...When I use the default MySQL port 3306, then I have no error.But when I use port 33060, then I get the error !My /etc/my.cnf :
Code:
[mysqld]
datadir = /var/lib/mysql
[code]...
Ubuntu Servers :: "service Mysql Status" Doesn't Work In 10.04.1
Sep 30, 2010I'm running Ubuntu Server 10.04.1 in Virtualbox environment with the host is Ubuntu Desktop 10.04.1.I have built a LAMP server after a fresh installation of Ubuntu server (I didn't choose LAMP to install when I installed this server) , everything works fine, but when I run "service mysql status" command I get this error: "status: Unable to connect to system bus: Failed to connect to socket /var/run dbus/system_bus_socket: No such file or directory"
I try in my desktop (also with LAMP installed) and I get the result like:
"mysql start/running, process 1218"
General :: Can't Connect To Local MySQL Server Through Socket '/var/lib/mysql/mysql.sock' (2)
Jun 2, 2010i 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.
Server :: Can Bind Dlz Work With The Mysql Stored Procedure
Jan 21, 2011I have some trouble when I build a DNS server. I need use mysql stored procedure work with the bind dlz mysql driver, but failed.
dlz "Mysql zone" {
database "mysql
{host=127.0.0.1 dbname=dnsdata ssl=false}
{select domain from domains where domain='$zone$' LIMIT 1}
[code]....
CentOS 5 Server :: Apache MySQL PHP Does Not Work On New Install
Jul 17, 2010I just installed Centos 5.5 on one of my systems today and something is eluding me. Basically I had a web site and forum software (phpBB, but I don't think it's that, other forum software like Xoops does the same thing) running on Fedora 13, and I copied it over to the new Centos installation. Apache is running fine and displays a PHP test file and .html files just fine.
MySQL seems to be fine, I can log into that, show databases etc. Just can't get any forum software to know there is MySQL there. I did change the path of the site, and the databases, and edited /etc/my.cnf and /etc/httpd/conf/httpd.conf to reflect that. Thought I made the needed changes in /etc/php.ini but who knows. Seemed like everything should have tar'd up and moved easy, but not the case...
Server :: SSH To Work Computer Behind A Firewall From Home Port?
May 5, 2010I have a computer which has a public IP.My ISP has allowed only port 22 for my machine to be accessed outside from internet.I want rest of my computers which are connected to this machine be accessible via SSH on internet.I can configure IPTABLES to route different ports to internal machines but since ISP has given only one port for the gateway how can I go for it any guesses. I came across some thing reverse SSH tunneling but that has to keep the connection alive all the time at gateway I want my trusted people to be directly able to access the machines on LAN to which they have account to login in this scenario.
View 3 Replies View RelatedCentOS 5 Server :: MySQL Shell Access Denied / Get It To Work?
Feb 20, 2011I'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.