I've setup a fedora core 13 server and I am running mysql on it. I wanted to use MySQL Workbench on my Windows 7 computer on the same LAN to connect to the database. Currently I am unable to connect to the database except if I go through ssh. What ports do I need to open on my firewall? Is there any specific configuration that I need to do to my MySQL database to get it working?
View 3 Replies
I am trying to get mysql to start at boot without any success.
The mysqld scripts works fine when run from the command line, but it does not work when i use the links created by chkconfig. I checked the boot.log and found that mysql starts but then it stops or gets shutdown. This is the log message:
Starting mysqld daemon with databases from /data/mysql [ OK ]
Starting cups: [ OK ]
STOPPING server from pid file /var/run/mysqld/mysqld.pid
starting DenyHosts: /usr/bin/denyhosts.py --daemon --config=/usr/share/denyho
sts/denyhosts.cfg
090727 04:35:47 mysqld ended
The same init script works fine in Ubuntu.
I 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.
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]....
long time user of redhat, first time user of fedora...
Installed fedora 10 to the hard drive (building a new web server, switched from RHEL5)
Started to install everything I need, apache, php, mysql, odbc, iseries access for linux, etc...
Got to the php modules, installed php-odbc, php-mysql, etc... but php doesn't see the mysql module
doing a phpinfo() produces -without-mysql
uninstalled it, reinstalled it (this is all done through kpackagekit so far) - no good
uninstalled and tried to reinstall via yum, no good
all the config files are fine - copied my php.ini from the old server and let the installs create the new mysql ini files
how to get it in ? this is my last step before i can begin pen and vulnerability testing it.
Has anyone been able to successfully change MySQL's default datadir in Fedora? I've tried on two machines now (F7 and F11), but run into the same problem on both. Here is what I did:
1. shutdown MySQL (service mysqld stop)
2. create new mysql directory (e.g. ~/mysql/) and set ownership to mysql:mysql
3. move tables from /var/lib/mysql to the new directory (I've tried moving only one user-created table, and also moving system tables with same result).
4. edit my.cnf and change "datadir" to point to new location
5. start MySQL (service mysqld start)
[Code]...
I am running a mysql 5.0.41 community edition server.i have a user x and i need to set max connection limit for the user... Can any one give the correct syntax to update the current user to include max connection for the user x.
View 1 Replies View RelatedHaving major problems with mysqld causing CPU usage to rocket to 100% on one core for a short time, which usually drops back down again to 1-7%, though sometimes it can last an extended period of time. This is a problem because things using mysql become unresponsive in this time.
[Code]...
I have a server (fedora 11 , LAMP). I want to know if I can upload something to my server via http (I mean from WAN),and this data stream can directly run into MySQL database . Do I need to write some special codes on my web page , or just change apache's configure file
View 7 Replies View RelatedI installed Fedora 12 with package standard of the MYSQL, configured this the same twirling in such a way localhost as in one it schemes with windows VISTA, to put I have others 4 you scheme with windows XP that I do not obtain to have access in the MYSQL. What I have to make pra these you scheme with XP to have access?
View 2 Replies View RelatedLet me show you the Details:
[code]...
So that means the User Test can connect from any host without password and with the named privileges, but he has no right to grant any privileges. CONSOLE:
[code]...
This is my first post. After executing /usr/bin/mysqladmin -u root password 'thepass' as a root, I get this:
Code:
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'
SELinux is off.
After securing webmin on my web server, with a custom SSL connection.I wanted to do the same with phpMyAdmin. But I am unsure of where to look for the best tutorial(s) to do this, can anyone help?Plus I saw once at work our network tech adding in accounts but then allocating that to the login itself.For example, when your brought up with a .htaccess prompt in the browser, thats assigned to you login within phpMyAdmin, taken from the db server no doubt, is it possible to do this?Should there be anything else I need to know in securing mysql?I have limited all services to a set number of IPs so non of its publically functional at the moment so I can take as long as possible, but naturally I'd like to be able to be as speedy as possible about getting this sorted.
View 7 Replies View Relatedis this command exact or do I replace anything with my own setu
" yum install mysql mysql-devel mysql-server "
who can't tell what has to be changed for "My server name" and "my setup"
I just installed FC12 x86_64. After a clean install I found that httpd, mysql, svn, svnadmin, etc are already installed. I still need to install and configure tomcat running as a worker behind httpd and configure everything. But my question is about security. What do I need to do to ensure that when I start httpd and mysql that they are secure? Are there default settings that I need to change? Are there security patches I need to apply?
System Config:
Fedora Core 12 x86_64
AMD Athlon II X2 250 3.0 GHz dual core
GIGABYTE GA-MA785GM-US2H
G.SKILL 4GB (2 x 2GB) 240-Pin DDR2 SDRAM DDR2 1066 (PC2 8500) Dual Channel Kit Desktop Memory Model F2-8500CL5D-4GBPK
it seems i have successfully installed LAMP.. i have a very basic page below that works when invoking "data()" but when i try to connect to mysql server (by removing the comments "//") it would just return a blank page.
[Code]...
I was installing a 2 server cluster ISPConfig3 with the help of GlusterFS. I was following this manual - Link
In the server the file /etc/glusterfs/glusterfsd.vol
Code:
# Configuration for the mysql server volume
volume posix-mysql
type storage/posix
option directory /media/big/myweb/export-mysql
[Code].....
I am not able to start mysql server...when i type command sevice mysqld start it saysMySQL Daemon failed to start.Starting mysqld: [FAILED]so how to solve this problem ?
View 10 Replies View Relatedanyone come across a mysql driver for Bind that is already in RPM format? I know there is one that you can compile, but i was just curious if anyone knew of a MAINTAINED package that does that same thing?
==Edit== While i'm at it, does anyone know of a way to have bind call a STORED PROCEDURE, instead of directly querying a table? That'd be sweet. --Or, even having bind query a php file, or a webhost, would be good... I'm going to google that one now....
==Edit== Screw the mysql driver: [URL]
how to use php to serve dns requests...
I've created a mysql user and he can connect Joomla to mysqld when everyone has full permissions to the mysql homedir but I know this is bad from a security standpoint. If I set mysql user as the only one with permissions then I can't connect. I know Joomla support is not very help from past experience, wish I could dump it for something else but it does work great once it is configured so I need to keep it around, can anyone make a guess as to what permissions I need to have set on mysql's home dir so that joomla can still connect yet I am more secure than now?
View 11 Replies View Relatedi'm new to MySQL and i designed a database using MySQL and PHP recently but dont know how to port it to my host company. How do i save the database on my flash drive then transfer to my host on my website's control panel.
View 1 Replies View RelatedTarget F12 mysql - 5.1.42-2
Source FC 5 mysql - 5.0.27-1
I've put SElinux into permissive mode as it was practically denying anything that moved. Both installed from the standard repos. I used mysql-administrator to create a backup of the FC5 server (all databases/tables) and transferred it to the new system. I restored it onto that machine and double checked that my standard admin user (full privs) was present and let me log in to make changes. All good so far.
So I copied over my files from my sites, point a browser at them and I get nothing, not even errors. Now it's a long while since I set the original up and have probably forgotten something simple but despite making the error output more verbose I can't seem to track anything down other than:
[Code]....
So it suggests my tables are invalid/trashed but I can't seem to figure out why. The original server is still running happily so I'm not in any rush to fix this, I'll keep plodding, Phpinfo reveals a normal operational php setup, so i think that side of the sites is functional. Apache test pages work on blank virtual hosts but viewing my sites reveals the favicon working fine but otherwise comepletely blank pages (zero output, even source). I tried running the page as a raw CLI input to the php package using php index.php and php returned nothing, logged nothing unusual but sat with my CPU at 100%, unsure if that is related.
My Linux server which is running my company website have been hacked. Today I saw a number of clients (customers) with some fun characters entries on my database. Access denial on really clients.
View 2 Replies View Relatedi'm not sure if this is because i'm having problems with my Raid setup, which mysql is running on, or if it is unrelated, but is anyone else noticing that mysql is VERY slow on Fedora 15?
View 5 Replies View RelatedI was trying to install MySQLbd (a module for python to connect and access MySQL) I followed these steps for installation[URL].. but while I am getting some installation errors. When I try to run $ python set.py build I am getting the following errors (I removed few errors as I can post more than 10000 characters here)
[Code]...
Mysql starting problem after changing mysqladmin password.I tried all the solutions available on forums, but not solve the problem.At last I restored the mysql db backup, this make mysql service start, but till other databases not showing all tables.
View 1 Replies View RelatedI am facing some strange problem of mysql replication with ssl, my replications which working fine from more than 6 months currently stopped working after i upgrade mysql in to newver version mysql-5.1.41-2, i create new ssl self singed certs but still no sucess, when client try to connect the master using ssl its gives error SSL connection error ERROR 2026 (HY000), with out ssl its working f9.
Platform --> Fedora-11 + mysql-5.1.41-2 (both master/client)
I can seeking the problem on net, and i found the below bugzilla url related to that.
[url]
I read it but not get , either new version support x509 ssl certs or not or either new version support ssl replication or not, here below my server configuration for ssl serts
And for client
Both server and clients certs are signed with same ca but still its currently not working after the mysql upgrade first 5.1.41 and then 5.1.41-2
Either as above bugzilla url, currently mysql support ssl replication or not, or either some need to do special for working with ssl. or i wait for newver version of mysql to fix if its bug or not.
I'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
I have the latest LAMP running on F10 but need to do a database conversion from mysql 4.1.22 to mysql 5 for a client.
View 4 Replies View RelatedI 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)
