i want to setup a mysql server, however,,there are no mysql packages version 5.1.53 in the opensuse 11.3 repo's even not phpmyadmin where can i find mysql, mysql-client, mysql-community-server for version 5.1.53?
View 6 RepliesI 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 CentOS5 and installed the MySQL for server during the installation. I can set up and use MySQL databases. But I cannot make it startup everytime the server restarts. And quite a lot of methods need this folder "support-files/mysql.server", while my set up cannot find this. I am wondering if my installation of the MySQL for server is complete or not.
View 4 Replies View RelatedI have a load balancer with 2 web servers behind it. The web servers rsync with cloud storage to update their apache directories 1 time every hour. Apache is just running php pages that pull/push data to a DB so they dont need to be updated that often. However I need to figure out how to implement a Master/Master MySQL setup to have my web servers point to for the PHP stuff. I need to implement it without having a single point of failure. The Load balancers are useless for failover as they only detect availability based on Ping request. So putting a master/master setup behind a Load Balancer is out. what is the best way to setup the master/master mysql in a HA setup without the use of a load balancer provided by the host?
View 2 Replies View RelatedI have just installed CentOS 5. I have set mysql database to access from remote machines. But now the problem is it is not connecting from the local machine now.
View 5 Replies View RelatedI am using CentOS5 and installed the MySQL for server during the installation. I can set up and use MySQL databases. But I cannot make it startup everytime the server restarts. And quite a lot of methods need this folder "support-files/mysql.server", while my set up cannot find this. I am wondering if my installation of the MySQL for server is complete or not.
View 3 Replies View Relatedi try to install mysql-server how do i create a password for it
yum install mysql mysql-server
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* base: mirror.optus.net
* updates: mirror.optus.net
[Code]...
I will preface this post by saying I am completely new to any flavor of Linux and even in Windows. I don't do much in the command line so I am very much at the steep part of the learning curve. I have Ubuntu Server 10.10 installed on a vm using VirtualBox. I installed the Server GUI, Apache and MySql using the command line. Now I want to be able to use a GUI for MySQL so it should be an easier transition coming from MS SQL. I downloaded MySQL Workbench which sounded like the add on I wanted. I have the .deb file on a CD. Now I have no idea how to put it all together.
View 1 Replies View RelatedGood tutorial, using images for a lamp server that has, MySQL,PHP, Apache, FTP with all the fruit for running a server that will host a Gallery, forum and main site
I know there's heaps around for Ubuntu 9.10, but its not quiet what I'm looking for as in Gd, ImageMagick and some extras for Apache mods
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'
[Code]....
On Windows and Mac it's as simple as downloading some WAMP and XAMP stack and clicking "install".
On OpenSUSE I'm trying to do it myself. I went into YaST and installed the "Web and LAMP Server" pattern.
Then I edited the default-server.conf file to point towards my website by changing the DocumentRoot and <Directory "blah blah"> lines.
Then I tried to start apache, but got the following error:
Code:
# apache2ctl restart
httpd2: Syntax error on line 188 of /etc/apache2/httpd.conf: Could not open configuration file /etc/apache2/sysconfig.d/include.conf: No such file or directory
So I just went into httpd.conf and commented out that line.
[Code].....
I'm try to setup a database server using mysql, the server starts fine, and I can access it using the built in mysql client via console (adding databases and tables works fine), but the problem is... I always get a connection refused error whenever I access the database outside the built in mysql client (example, if I write a code that connects to mysql). So, I tried execute an nmap command and the only ports open are these ports:
[Code]....
there's no 3306 for mysql... I'm thinking that the firewall is just blocking the port that mysql is using, but my question is, how could the built in client connect to the server if there's no open port for mysql server? Don't clients usually access a servers through ports?
how to set up a mysql database on a local machine?
View 9 Replies View Relatedi am trying to set up LAMP on an old pc i have installed linux, apache, mySQL and PHP following this guide Installing Apache2 With PHP5 And MySQL Support On OpenSUSE 11.3 (LAMP) | HowtoForge - Linux Howtos and Tutorials. i have installed phpMyAdmin but when i try and acess it i get this error
Error
MySQL said:
Cannot connect: invalid settings.
phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.
[Code]...
I started over combining the first parts of this guide: [URL]..ubuntu8.04 (Only the first few parts in terms of configuration and naming). Then I used this guide: [URL]..Surprisingly enough all steps worked.
1. Now I need to set up LAMP servers with MySQL master/slave replication and Apache rsync.
2. Next i need to add BIND to both my Load Balancers with master/slave backup and replication...
Are there any guides to look at to follow on these? Can tou point me to the right direction for BIND with replication.
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 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.
what the difference is between msql-server and mysql-community-server
View 5 Replies View Relatedi am using putty to connect to my server and wanted to restart mysql server. searched the internet and found thatcommand is /etc/init.d/mysqld start or stopbut it did not worked.then tried /etc/init.d/mysql stop or startthis also did not worked.
View 6 Replies View RelatedI consider myself a linux noob. The thing about this is, I have played around with various distros of linux over many years. Eventually I get frustrated at how ridiculous something as simple as text editing can be. I'm having a problem starting mysql. I have already ran the install script afer downloading mysql community server from yast.
what I need to do to start the server. I tried to issue rcmysql start, but it says "The absolute path to 'rcmysql' is 'usr/sbin/rcmysql' so running it may require superuser privileges. So i say SUDO rcmysql, enter password and again same message.
I have a small home-office network. On that network I have two linux computers, one is a client the other a server.
On the server I have NFS Server setup and mount some NFS exports on the client computer.
On the server I have the firewall on and here it becomes a little tricky.
Since both the server and the client connect to the router the interface (eth1) is theoretically both an internal & external zone.
The router is commercial grade and therefore has a good firewall on it which is also setup. Therefore the firewall on the server is really more of a backup than a necessity. But that's fine, and by having the server's firewall on 'fail2ban' is able to work which I like to have working so I don't want to just turn off the server firewall even though I have good security from the router.
However, when I turn on the server's firewall, the client computer cannot see the NFS server when scanning for server -- done by: clicking on "Choose" next to "NFS Server Hostname" when adding an NFS share in the NFS Client in YaST. Clearly something is being blocked even though I have both "NFS Client" and "NFS Server Service" allowed in the server firewall. The Firewall config. files for these are below.
The Firewall configuration is pretty much "out of the box". That is I have the services I need opened up for the external zone, the other zones are left at their default which means the internal zone, although not used (i.e.: attached to any interface), is completely open.
The perfect solution I guess would be to setup my client computer to connect through a different NIC (perhaps eth0), make that the "Internal Zone" and therefore allow all traffic through to it while still blocking the server from the external zone. However, I cannot make that physical change to my network for now so I am looking for an in between (non-perfect) solution.
In this case I am guessing that means opening up extra NFS ports to the external zone so I have full NFS functionality. I don't mind this because like I said, the router firewall is the main line of defense anyway.
So, given all of the above could someone tell me what I would need to additionally open up in the server firewall to make the NFS server detection work on the client while the firewall was on. Or, if you have a cleverer/better solution without me changing my physical network that would be great.
Hopefully I have written this in enough detail and clearly enough so that all the parameters are clear but if not, feel free to ask me what you like and I'll try to make it clear.
Code:
## Description: Firewall Configuration for NFS kernel server.
#
# Only the variables TCP, UDP, RPC, IP and BROADCAST are allowed.
# More may be supported in the future.
code....
I want to set up the following server in open suse:dhcpopenldapnfs (to allow users to mount their home directories from the serverI started off with the openldap server. I configured it with dc=localdomain,dc=local as its domain. As the server machine has no internet. Though when I go to add a .ldif file with the following command
Code:
ldapadd -x -D 'cn=Administrator,dc=localdomain,dc=local' -f /home/base.ldif -W
It returns this
[code]....
I installed the latest version...Everything works like a charm. I have Windows Home Server 2003 running and would like to access all of my folders. How can i setup OPENSUSE to find/access my Windows Home Server 2003. Can you help me with this. Just to let you know. Am i missing something so i can access them locally.
View 1 Replies View RelatedI 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'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
Enable remote access to MySQL database server I used the link above to enable remote access to mysql for a specific user. But when I try to telnet 3306 or user mysqladmin to connect, both just hang there. Using mysql 5.0 on opensuse 11.1
View 1 Replies View RelatedI installed and configured mysql 5.0 on my opensuse 11.1 box. But I have no idea how to get it to start automatically when the server reboots.
View 3 Replies View RelatedI'm trying to setup wordpress on my server, which of course I need mysql for. I setup a database the other day, which worked perfectly, but I had to start again as I put some information in wrong. Now, I can create a database fine, but when I run
Code:
GRANT ALL ON wordpress.* TO wordpress@localhost IDENTIFIED BY "password";
I get the output:
[code]...
I have MySQL 5.1.34 and PHP 5.1.6 installed on my system, how do I install php-mysql? Each time I try, it says
mysql-5.0.45-7.el5.i386 from base has depsolving problems
-- > mysql conflicts with mysql-server-community
error: mysql conflicts with mysql-server-community