I 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]...
Running 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.
iam 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)'
I 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.
php can't connect mysql by 'localhost' but can connect by IP address:
[Code]...
I installed required updates on my linux installation (ubuntu 9.4) I am now unable to access my localhost, and get the following message from my browser: Failed to Connect Firefox can't establish a connection to the server at localhost. Though the site seems valid, the browser was unable to establish a connection. I checked my hosts file which has the following information:
[Code]....
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.
I 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 RelatedI have two new Fedora 12 installs and both fail to complete the install and configuration of MySQL. When I run mysql_install_db I get:mysql_install_db --verbose Installing MySQL system tables... OK Filling help tables... OK
To start mysqld at boot time you have to copy support-files/mysql.server to the right place for your system
Please remember to set a password for the MySQL root User
To do so, start the server, then issue the following commands:
/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h server.domain_name password 'new-password'
Alternatively you can run:
[Code]......
I'm having problems connecting to the mysql database on my system. I first noticed this when I was trying to set up the program anymeal. I subsequently tried using MySQL Administrator (mysql-admin), but had no luck. It gives my the following feedback:
Code:
Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Click the 'Ping' button to see if there is a networking problem. I press the ping button, and it seems to connect.
Code:
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 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)
I just finish tring to get my mail server running but I get an error in my mail.log
Jan 21 16:33:08 server imapd-ssl: Connection, ip=[::ffff:67.223.78.XX]
Jan 21 16:33:08 server authdaemond: failed to connect to mysql server (server=127.0.0.1, userid=postfixadmin): Access denied for user 'postfixadmin'@'localhost' (using password: YES)
Jan 21 16:33:08 server imapd-ssl: LOGIN FAILED, user=jason@[mydomain].com, ip=[::ffff:67.223.78.76]
Jan 21 16:33:08 server imapd-ssl: authentication error: Input/output error
I have the right password in all the mysql config files and tried to reset the password in the sql database with no luck. I granted perms to all and its still giving me the error.
I have an intel i7 with windows7 64b , then install VMware Workstation and create a machine with Oracle enterprise Linux 64b 5update4, now i want to inatall oracle db10gR2, but this message apears. [oracle@localhost database]$ Exception in thread "main" java.lang.InternalError: Can't connect to X11 window server using 'localhost:0.0' as the value of the DISPLAY variable.
at sun.awt.X11GraphicsEnvironment.initDisplay(Native Method)
at sun.awt.X11GraphicsEnvironment.<clinit>(Unknown Source)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
[Code]...
Trying to run kismet but get errors on opensuse 11.2 64 bit- error message I get is. Could not connect to Kismet server 'localhost:2501' Question:What do i need to change in the settings, the following are the default ones.
[Code]...
I have installed bind from the repos and am trying to setup a caching name server. After copying the stock name-cachinging.conf to named.conf, I tweaked named.conf to reflect my LAN:
options {
listen-on port 53 { 127.0.0.1; 192.168.1.102; };
listen-on-v6 port 53 { ::1; };
[code]...
I have a strange problem with evolution in Fedora 14. I run my own mail servers (Postfix and Dovecot) on localhost. This all worked great in F13 but now evolution refuses to connect to the localhost imap server. If I connect from my laptop (also F14) i.e. not from the localhost all works fine and great with evolution. I deleted all the config and started again to no avail. I also created a new user and logged in with this user and I still get the same so looks not to be user config issue.
evolution --debug=evo.debug.txt returns nothing useful.
Dovecot is listening on localhost as I can telnet to the imap port. Also other imap clients like Thunderbird work fine.
I am getting the following error when starting mysql using 'sudo /etc/init.d/mysql start':
Mar 15 16:33:56 MoodFishDev /etc/init.d/mysql[18317]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Mar 15 16:33:56 MoodFishDev /etc/init.d/mysql[18317]: ^G/usr/bin/mysqladmin: connect to
[code]....
I tried to install php from source file on centos server and i got the error as # ./configure --with-apxs2=/usr/local/packages/apache/bin/apxs --with-mysql --prefix=/usr/local/packages/apache/php --enable-force-cgi-redirect --disable-cgi --with-zlib --with-gettext --with-gdbm
checking for specified location of the MySQL UNIX socket... no checking for MySQL UNIX socket location... /var/lib/mysql/mysql.sock checking for mysql_close in -lmysqlclient... no checking for mysql_error in -lmysqlclient... no configure: error: mysql configure failed. Please check config.log for more information.
what is happening on my Centos virtual server (ps I'm having a great time re-learning Linux after a large gap and usually try and find out myself but this has me confused) First thing I did was install Tomcat and try and change the port to 80 using iptables -nat and it complained a kernel module was missing. Instead setup Apache to redirect requests so that's now working I then tried to install CSF firewall and the validation perl script returned fatal errors so I assumed OK my virtual server Kernel is restricted and used denyhosts instead which is working great
Here's the confusion.. I later retried the csftest script and it now works including all the iptables and nat stuff that fataled before. I've not rebooted or changed anything except run denyhosts and the postgres daemon + ended a few daemons that I didn't need (eg pickup,tlsmgr,courier,postfix,qmgr,saslauthd) Running lsmod returns nothing and /proc/modules is zero bytes so I'm not able to tell what is loaded? I'm tempted to try and get Tomcat redirecting via iptables and see what happens but if it works I don't like that something seems to have changed.. before I ran it direct as root now I'm SU into root from another login
I'm using slackware 13.1 and I have a problem to accept remote access to mysql server.The steps I have followed to do that thing are:vi /etc/my.cnfline skip-networking is commented
bind-address my_ipaddressI opened the port 3306 of my firewallAlthough I can connect locally, i.e. mysql -u a_user -h localhost -pI can't do it remotely i.e. mysql -u same_user -h my_ipaddress -pI have also turned off my firewall, but nothing.telent 3306 my_ipaddress results in: telnet: connect to address my_ipaddress: Connection refusedMy my.cnf file is:
Code:
[client]
port= 3306
[code]....
I wrote a code in C to connect to MySQL by using mysql_real_connect function but I recieved error "Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)" (by using mysql_error function).
I also did the following things: in mysql I typed 'SHOW VARIABLES LIKE '%SOCKET%'', it returned /var/lib/mysql/mysql.sock I typed 'mysql_config --socket' in shell, it returned /var/lib/mysql/mysql.sock I modified /etc/my.cnf file
I'm trying to set up Apache to do test dev, so I don't have a "fully qualified domain". If I enter the hostname as the ServerName in httpd.conf when I restart httpd I get the error_log message:
PHP Code:
[code]...
Sometimes I can get it to work, but it won't run on boot and right now even when service says httpd is running I can't reach it from another computers browser.
Mysql can't start after I uploaded my.cnf file in /etc directory before that everything was okay but after I uploaded my.cnf and then restarted the mysql it can't boot
Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!
I tried to delete my.cnf and try again but the same error ...
Im getting this error when i try to run mysql from a shell
Code:
ERROR 2002 (HY0000): can't connect to local MySQL server through socket
I have installed MySQL over yum on fedora.
but the path and file /var/lib/mysql/mysql.sock does not exist on my system?
I've tried /etc/init.d/mysql start, and it actually starts, or at least, it doesn't error out. But when I do pgrep mysql I get nothing, and when I try to login with mysql -p as root, I get
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
None of my other logins work, either, but since pgrep mysql didn't work, it's clear that MySQL just isn't running. I tried uninstalling and reinstalling mysql-server via apt-get, but I get the same thing. The logs in /var/log/syslog show this:
Apr 11 14:31:26 /etc/init.d/mysql[9774]: #007/usr/bin/mysqladmin: connect to server at 'localhost' failed
Apr 11 14:31:26 /etc/init.d/mysql[9774]: error: 'Can't connect to local MySQL server
[code].....
I have an e-mail production server that has been running fine for almost two years.
Notice mail was not serving today and login to a bunch of errors in messages
However, I think they are all from not being able to access MySQL and when I:
mysql -u root -p
I get:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
I would like to connect to a separate mysql server, yet I can't find any documentation on how to do this.How would one achieve this? I am running qmail on centos4.
View 3 Replies View RelatedI cannot connect to mysql on my server.It is running but I cannot remember whether it has a password or not.I get this: [root myscripts]# mysql ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)[root myscripts]#.I have tried running mysql -u root -h localhost -p and entering a blank password but no luck.
View 5 Replies View Related