In my Ubuntu 10.10, following this tutorial, I don't face step 2. I mean, while installing the packets, I don't face anything related to configuration.Then, when I run a command, such a
Quote:
mysql -u root -p
, I get this error:
Quote:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
I've setup a CentOS apache web server, and loaded a site onto it. The site previously was functioning under windows xp (before I "stepped in") and wamp. What I did was copy the site in /var/www, reconfigure the httpd.conf (DocumentRoot /var/www/site, etc). Although when I try to open the webpage I get this error: Database Error: Unable to connect to the database:The MySQL adapter "mysql" is not available.
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
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.
We started our project (it's a website "employee performance appraisal system") in windows by starting with some html forms and then slowlyadded php ,javascript and other stuff in windows we had no issues of insertion and retrieval of data from thedatabase.Now,we decided to shift the entire stuff to drupal the html forms along with those php files but we had 2 issues with this1. the first one was ..we created "page" for each html form and copied the html code into "page" but we didn't find where our pages are getting stored (do they get stored in mysql database that we create for drupal siter do they remain as html pages somwhere?)2.second problem was ...for admin in drupal I gave the username "root" and a password ..similarly for mysql also I gave a password.
now I used phpmyadmin and created another database called "appraisal" which is supposed to hold the data of our website.when I try to insert data into one of the tables of this database (attendance table) ,the following error occured "Attempt to connect failed access denied for user 'root'@'localhost'(using password:NO) cannot run querry insert intoattendance values('x','y')" Access denied for user 'root'@'localhost' (usingpassword:NO)Also I'm unable to access mysql as a normal user only super user can access and can we unset the password that's required to reach mysqlprompt?
I'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.
In looking at the release notes, I saw the comment File locations changes:
* MySQL socket file and pid file were moved from /var/lib/mysql to more reasonable location /var/run/mysql by default.
* MySQL log files are in /var/log/mysql. Not sure what I was supposed to do with that information. So I ignored it. Now, I am finding some issues with it. The web server works, but any connection to the database fails with 2002: Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (2)The thought dawned on me that maybe all my databases were erased and none set up. Going in to the terminal, I could connect and list and query the databases. So even though I backed them up, they still are there!
phpMyAdmin gives the same error message.
However, when I go into MySQL Administrator, it works fine.
I forgot where I saw it, but the socket is still set to var/lib/mysql. I could not find any mysql install log and would say what was in my cnf.my, but it still doesn't exist just as it has not in the past. Not sure if I should allow the MySQL Administrator to create it since I always ignored the prompt in the past and it worked. (Just wishing to keep the defaults)
At first I thought the upgrade upgraded the MySQL, but it's still 5.1.39 as I believe before. I've un-installed mysql-server and re-installed it with no change.
Can anyone can tell me how to get the socket to /var/run/mysql or what else is wrong? I read one place where mysql is supposed to set it up.
In my system I installed Oracle enterprise linux.while installing I installed Mysql also.
I checked the version which is 5.0.15
After my installation,I am installing Bugzilla 4.0.at that time it's showing below =========================================================== Checking for DBD-mysql (v4.00) found v3.0007
For MySQL, Bugzilla requires that perl's DBD::mysql 4.00 or later be installed. To install this module, run the following command (as root):
/usr/bin/perl install-module.pl DBD::mysql =========================================================== I ran below command #/usr/bin/perl install-module.pl DBD::mysql
I am looking into setting up replication in a production environment but currently this is on two test machines. I am following the documentation at [URL] but I am unable to get past "16.1.1.10 Setting the Master Configuration on the Slave". When I do the CHANGE MASTER TO I am getting a syntax error for some reason. What am I doing wrong? These servers run "CentOS release 5.5 (Final)" and "MySQL 5.0.77-log Source distribution" installed via yum. The only changes from default are that I created a single database on the master before doing the table lock and dump, then everything else has been done exactly to what the documentation states, but is still failing.
The option skip-networking is not in the config file on either server and neither one runs SELinux or any firewall.
mysql> CHANGE MASTER TO -> MASTER_HOST='192.168.1.220' -> MASTER_USER='repl' -> MASTER_PASSWORD='removed'
After the Opsview packages have been installed, it is necessary to configure Opsview and its databases.but while running below command get an error,#mysqladmin -u root password {password}mysqladmin: connect to server at 'localhost' failederror: 'Access denied for user 'root'@'localhost' (using pa
I'm running: OpenSuSE 11.1 MySQL 5.0.67 MySQL Administrator 1.2.12
I have one database for my web application. It's using MyISAM tables. In MySQL admin, I went to Backup and created a scheduled backup project called backup1. On the advanced tab, I selected "Lock All Tables" and checked the box for "Backup Selected Database Completely". On the Schedule Backup tab I have "Execute this Project Daily" selected and the time 1AM. The target directory is set along with the connection name. The connection it's using is the same MySQL user that my web application uses in order to utilize the database. It has full access to that database. Now when the backup file is created, it backs up no data at all.
Instead in creates files that are 580bytes in size. When I open the files they contain: -- MySQL Administrator dump 1.4 -- -- ------------------------------------------------------ -- Server version5.0.67
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
I have installed on a remote server phpmyadmin 3.3.1 and mysql 5.1.46 on a centos 5.4 OS.
Any newly created user with phamyadmin is unable to login both from mysql command line (from localhost) and phpmyadmin (localhost and remotely).
No prob when the user is created with mysql command line (from localhost). All of the users created with phpmyadmin, are not "visible" recognized from the show user command via the mysql command line. The setting I used when I create any user was the same as the ones with the mysql command line creation.
The error message I get when accessing from mysql command line (from localhost) is the following: "Access denied for user ... @localhost (using password: yes)"
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.
How can I really, really remove everything related to mysql / mysql-server. I read and tried all kinds of things, but on every reinstall there is still old mysql stuff there, for example an existing password. Even resetting the password does not help.
Reason of removal: it looks like the mysql setup is really corrupt, so I want to remove, and then do a fresh install. Running Ubuntu 11.04 64-bit
sander@R540:~$ sudo apt-get purge mysql-server Reading package lists... Done Building dependency tree Reading state information... Done Package mysql-server is not installed,
I'm an absolute biginer with UBUNTU witch I just install to start trainning PHP/Mysql. I've instaled UBUNTU Desktop. Is it enough or should I install UBUNTU Server? That is, can I install PHP and MySQL on this DESKTOP version?
I'm trying to install the squeezebox server software in Ubuntu 9.10 and I'm getting an error when it tries to install mysql-server. Seems like people have run into this before [URL]... but so far, I can't find a solution.
