I've successfully installed mysql using yum on the latest fedora; and started it like so:
What do I do from here!
I used the command: whereis mysql
I found out it was in /usr/bin/mysql /usr/lib/mysql /usr/share/mysql ../man/man1/.gz
I attempted to execute it from root.. bin and I get the following error message:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket 'var/lib/mysql/mysql.sock'
i'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 want to install mysql on my system. I have downloaded rpm from mysql website.
I fired rpm -ivh MySQL-server-5.5.15-1.linux2.6.i386.rpm. The result was error:
Then I tried with this command rpm -Uvh --test MySQL-server-5.5.15-1.linux2.6.i386.rpm. The result which I got was error:
How to find the dependencies or some other way to install mysql-server on my system. Or how to install it with the help of yum?
Im using centos. I have install rpm for mysql
But when i have enter service mysqld start it shows mysqld: unrecognized service
And when I type mysql it shows ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
To install mysql follow this process. Go to your Terminal and Enter the command given below:
Code:
After installation you need to start mysql server by
Code:
After this you need to enter this command
Code:
1.First you system will ask you old mysql root password if you have installed mysql just now and not set password yet then you can enter anything or just press enter.
2. After that system will ask you twice for new password you can set a new password or you can keep it blank for no root password. I will suggest you to enter a password.
3.remove anonymous user? make it yes when you install mysql an automatic mysql user has created so remove it.
4. Disallow root login remotely. Hope you want to disallow mysql root login from remote for security of your mysql sever. If you want to use you can select no.
5. Remove test database. As anonymous user system generate and automatic database for testing.select yes to delete it.
6.Reload privileges: do yes to flush privileges.
Now you can login in your mysql server as root by this command
Code:
One more thing make sure that when you are entering this command you login your terminal as general user not as root.
Now you can create a new user by following commands.
To create databases
Code:
To see database list
Code:
Code:
Code:
Code:
Code:
Code:
If you want to work with mysql in gui mode Then you can install phpMyAdmin to install phpmy admin go to terminal and eter
Code:
And after completing installation you can login in to phpmyadmin. To login go to your browser enter [url] or Click here or you can download mysql gui client Mysql Work Bench from mysql website or Click here after installation it will be appear in programming menu. It's also cool client with mysql server activity watcher.
I'm thinking about installing a DNS server on Fedora 13 running bind. I looked around for available bind packages and found only these:
Now the first one contains bind utils the second one is for running DNS in a chroot env and the last one is a bind with some DB backend.
Does this mean that fedora 13 doesn't support/.provide "standard" bind server (I mean the one to run without chroot/without db backend) ? Or am I missing anything in my repolist which is :
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 looking to get wifidog running on a Centos 5.4 box. I understand wifidog runs with PostgreSQL as its database by default. I have been looking online, and I cannot find how to get wifidog running with MySQL instead of PostgreSQL.Does anyone out there know how to get wifidog running with MySQL and tell me how to do it?
View 2 Replies View RelatedI'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)
I run Ubuntu 10.04. For some reason, MySQL won't start on startup. How do I make it run on startup? I installed it by installing LAMP using tasksel and did everything according to: [URL]. Also, I have another problem: When I try to start/stop/restart mysql in the terminal, the terminal will not give me any prompts after entering the command. E.g., after entering "sudo service mysql start", nothing will happen. Even after waiting for 30min, nothing happens.
View 9 Replies View RelatedI am struck with this problem since yesterday, Everything was working fine until i got a sudden error saying[Warning]: PDO::__construct() [pdo.--construct]: [2002] No such file or directory (trying to connect via unix:///opt/lampp/var/mysql/mysql.sock) (Database/class.SWIFT_Database.php:330)Then i went into server and restarted server. it started saying
/opt/lampp/lampp restart
Stopping XAMPP for Linux 1.7.4...
XAMPP: Stopping Apache with SSL...
[code]....
I just took a class on sql, unfortunately, it was Windows-centric, which means I have to figure out how to do stuff in Redhat by myself. By installing mysql via yum and then running pirut, I find there is an interface type program called MySQL-python-1.2.1-1.x86_64 so I installed it but I'll be danged if I can find any information on how to actually run the thing. What is the command to start MySQL-python-1.2.1-1.x86_64?
View 6 Replies View Relatedi have apache and mysql running, i can access my web server by visiting localhost on port 80 but for some reason when it doesnt work when i try using my ISP provided IP address... (it used to work).. i have my router setup with a DMZ on my LAN IP (my computers IP, this is the computer in my home network that serving with apache).. i also cant seem to shut down my mysql server (theres an update ive been trying to get) even when i use sudo...
View 5 Replies View RelatedI was installing zabbix and had to make some mysql stuff work... couln't remember my mysql password, so figured i'd uninstall mysql and reinstall. so i did:
[code]...
i was admittedly stoned when doing this, but it has uninstall a LOT of other stuff. including xbmc. no problem, i'm an idiot but i'll just reinstall xbmc and the other stuff
[code]...
how i can get this running again or would it just be easier to reinstall.
I have just installed joomla and proceeded to do the web install. Got the interface up and running and its now complaining it does not see the mysql server running. I do in fact have it running. Veryfied it with mysql command on command line and it complained with missing attributes.
I read a thread that it needs php-mysql installed. So went to proceed to install it. Well, I did not have that and went to install it. Verified it. Package mysql-server-5.0.77-3.el5.i386 already installed and latest version
I then did a service mysql reset.
Checked back at the joomla web install interface and still, it says there is no mysql support! What is next? Im running centos OS. Also, I am running LAMP
I have ubuntu 9.10, and installed the latest lampp with default options. Apache/Mysql/Proftpd would start and stop fine. I then did:
...which I got from here...[url] Although I'm pretty sure I was never prompted for the mySQL password. At any rate, now mySQL will not start (Apache and ProFTP are OK). Where can I start debugging this? Where is the conf file for mySQL?
Since /etc/rc2.d/S19mysql does not exists anymore, and then init.d/mysql uses /sbin/start, I am unable to use mysql server anymore: me@mycomputer~#start mysql [ret] ...... for hours this command never returns so that ^C aborts...
me@mycomputer~#ps axw |grep mysql ( no results, no mysql!!! ) me@mycomputer~#stop mysql [ret] no returns either!!! This upstart [start|stop] thing seems a total failure for mysql!!!
from nmap localhost | grep mysql command i will come to know whether mysql server is running or not.my problem is i want to test whether mysql server is running or not in shell script and if it is running i need to tell the user to stop the server to run the shell script.
View 3 Replies View RelatedAfter a new install of Slackware 12.2, I carried out the following procedures to get everything working successfully right out of the box. The server is a standalone system, used for testing and educational purposes, so please bear that in mind. NB: Throughout this post when you see a single # at the start of a line it means you are typing the commands as root user. You should not include the #, only the text after it.
### setup Apache with php enabled
Login as root user on your Slackware box and type:
# pico -w /etc/httpd/httpd.conf
[code].....
I am trying to install Fedora alongside Ubuntu but have run into a bit of a snag. I have the ISO burned to a disc, but it will not load on startup and doesn't have a prompt when the cd loads normally. I have files on the cd, but Ubuntu cannot read them.
View 7 Replies View RelatedI 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 installed mysql on Ubuntu linux with the command apt-get install mysql-server. How do i competely uninstall it?
Is there a way when i install the server to configure the server options (e.g. where the data directory is). I know how to change this once installed but i was wondering if there was a way to do it during the installation for ease. All i remember from the installation procedure is that you can set the root password.
I tried to install the package from centosplus repo but got the error cannot find libmysqlclient.so.15.Not surprising as I have libmysqlclient.so.18. If not does anyone know how I can build postfix with support for MySQL 5.5. It doesn't help that I have never built a binary before - I found a couple of good tutorials on how to build from source that seem straight forward enough but I have no idea what needs to be specified for the postfix build.
running CentOS 5.6
MySQL5.5 (Remi)
PHP 5.3.6 (Remi)
Today I'm installing MySQL for my Django server!
I installed:MySQL-server-5.1.48-1.glibc23.i386.rpm MySQL-client- .1.48-1.glibc23.i386.rpmand can now type "MySQL" at the command prompt to play around with MySQL! W00t!
However, when trying to import MySQLdb into python, I get this error: >>> import MySQLdb ImportError: libmysqlclient_r.so.15: cannot open shared object file: No such file or directory ... and now I'm clueless. I tried looking for libmysqlclient_r.so.15 by typing "sudo find / -name 'libmysqlclient_r.so.15'" and didn't get anything
Im trying to install mysql by this code..
But at the gunzip stage its showing "no such file" though the path is correct..im not getting that the code is correct or not?
I have a problem installing mysql ruby gem on 64bit CentOS machine.
[jacekb@vitaidealn ~]$ uname -a
Linux vitaidealn.local 2.6.18-92.el5 #1 SMP Tue Jun 10 18:51:06 EDT 2008 x86_64 x86_64 x86_64 GNU/Linux
I have been trying to install the above on my CentOS 5.5 server but am having missing libs issues. Our friend yum is not helping either. Here're some of the libs missing:
Missing Dependency: liblua-5.1.so()(64bit) is needed by package mysql-workbench-gpl-5.2.31-2el6.x86_64 (/mysql-workbench-gpl-5.2.31a-2el6.x86_64)
Missing Dependency: libssl.so.10()(64bit) is needed by package mysql-workbench-gpl-5.2.31-2el6.x86_64 (/mysql-workbench-gpl-5.2.31a-2el6.x86_64)
Missing Dependency: python(abi) = 2.6 is needed by package mysql-workbench-gpl-5.2.31-2el6.x86_64 (/mysql-workbench-gpl-5.2.31a-2el6.x86_64)
[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.