Let 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]...
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 RelatedI 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 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 have so far: installed and configured postfix, installed courier, installed MySQL and SASL. mostly following a guide on [URL]
When I want to login via POP3 with a user from the MySQL database, authentication fails.
The mail.log file contains the followiung error:
Nov 25 18:47:55 asmahan pop3d: Disconnected, ip=[::ffff:10.11.39.33]
Nov 25 18:48:05 asmahan pop3d: Connection, ip=[::ffff:10.11.39.33]
Nov 25 18:48:16 asmahan pop3d: LOGIN FAILED, user=john, ip=[::ffff:10.11.39.33]
The problem only occurs when I try to login via POP3. I can send emails via SMTP using the same account without any problems.
At first I thought the Delay was normal. After looking around it seems that it's not true. I made a post here. The Problem seems to be related to DNS.
The Server in Question is not Online (as in on the web), all machines are on local ethernet. From What I understand DNS is to mask the IP like a named variable for each IP. I am still figuring out the ins and outs of a linux server. DNS is something I have little or no grasp over. So I need help in setting up the DNS for this scenario case. All guides I have seen seem to be for web servers which is where I stop reading and look for other guides. I have webmin and Bind9 installed on the server.
I am trying to update my server, but it won't do it. It tries to connect, but says "Waiting for headers". If i try to install other packages it says "Connection failed". Apparently it has Internet connection since my server shares Internet connection with other machines.
View 9 Replies View RelatedI am using Ubuntu Server 10.10 64bit. While executing apt-get update i am getting error Connection failed. I have checked other post also some where i found to change the country name 'us' to other present in repository url inside /etc/apt/sources.list file. I tryied with country 'de' and 'in' but then also got the same error. I am getting following error
[code]...
I'm trying to setup a new Ubuntu Server via terminal to host a variety of websites. I need quite a bit of space, so our Windows System admin set me up with an iSCSI connection to a drive array, however I'm a little unsure how to translate that and get the is open-iscsi service connecting to it.The settings he sent me include:
DNS Domain Name
two IP Addresses for it
A Name for the service: pd2_video
An IQN:
He enabled CHAP with a username and password.Where do I need to look to see documentation on how to connect to this service?I have tried following: [URL] However I get:
iscsiadm: connection to discovery address x.x.x.x failed
figure out this error?
Code:
kradalby@hpcompaq6530b-laptop ~/.ssh $ ssh -vvv -p 110 kradalby@dfekt.no
OpenSSH_5.5p1 Debian-5+b1, OpenSSL 0.9.8o 01 Jun 2010
[code]....
I using Fedora 12. When I am going to start MySQL server then error is come
MySQL Daemon failed to start.
Starting MySQL: [FAILED]
MySQL Details :
mysql-5.1.42-2.fc12.i686
I have a fedora 14 box and a windows box running on the same LAN. I can not connect to mysql from my windows box using the workbench GUI.
When I try to telnet my fedora box I get this :
SSH-2.0-OpenSSH_5.5
quirt
Protocol mismatch.
Connection to host lost.
C:UsersMichael>telnet 192.168.1.2 3306
[Code]...
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]....
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 View RelatedI need to connect to my company through a Cisco VPN. The Cisco client fails to build so I thought of using vpnc. I used Network manager (NetworkManager-vpnc is installed). However after setting everything up and then logging in, I get the 'VPN Connection Failed' message.
View 14 Replies View RelatedI am not sure why sometime ssh failed to connect from my old Suse at home (Linux POMDESKTOP 2.6.18.2-34-default #1 SMP Mon Nov 27 11:46:27 UTC 2006 i686 i686 i386 GNU/Linux) to my Fedora core 14 at work. I used the command
"ssh -X -l login_name IP_of_fedora"
Sometime it connected very fast but most of the time error with 'connection time out'. Also ping remote desktop often failed. How I can get reliable connection every time. Both desktops has been rebooted several times and both have internet access.
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]...
Having 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 RelatedThis 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].....
anyone 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...