CentOS 5 Server :: Mysql-server How To Setup Password

Aug 30, 2009

i 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]...

View 1 Replies


ADVERTISEMENT

CentOS 5 Server :: MySQL Server Setup For Remote Access

May 4, 2009

I 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 Related

CentOS 5 Server :: MySQL Setup Without 'mysql.server'

Jul 14, 2010

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 Related

Server :: Unable To Setup Replication In MySQL 5.0.77 On CentOS 5.5

Jun 21, 2010

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]....

View 3 Replies View Related

Ubuntu Servers :: Setup The MYSQL Server - Error: 'Access Denied For User 'root'@'localhost' (using Password: NO)'

Mar 26, 2010

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)

View 4 Replies View Related

Server :: Setup Password-less Ssh On Two CentOS 5.5?

Apr 11, 2011

I was able to setup password-less ssh on two CentOS 5.5 servers, I don't encounter any problem on root account but when I try on another user it fails and ask for a password

This what I've done.

centostest1 = Source
centostest2 = Destination

On Source Server (centostest1)

1. ssh-keygen

2. ssh-copy-id -i id_rsa root@centostest2
ssh-copy-id -i id_rsa user@centostest2

3. Now to test
ssh root@centostest2 <--- no problem, no password needed
ssh user@centostest2 <--- problem, it asked the password for user

View 8 Replies View Related

Server :: Setup An Ssh Server That Doesn't Require A Username,password Or Cert To Login?

Jun 22, 2010

Is it possible to somehow setup an ssh server that doesn't require a username,password or cert to login?I wish to provide shell access to a console program, which will prompt for a username and password.Encryption is essential though, and users must not be able to snoop in on each other

View 9 Replies View Related

Server :: Setup RAID 1 On CentOS 5 Server For A Zimbra Email Server

Feb 7, 2011

I'm trying to setup RAID 1 on a CentOS 5 server for a zimbra email server.I get a partion schema error. Can I do this?The server is a HP Proliant ML150 G3 server with two 80GB HDD.

View 1 Replies View Related

Server :: MySQL Setup Without "mysql.server" In CentOS5

Jul 14, 2010

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 3 Replies View Related

Server :: Unable To Setup A NIS Server Setup On CentOS System

Jan 19, 2010

We are trying to set up a NIS server on a CentOS system. We need to have a NIS server which can provide NIS authentication to a couple of clients. We are practically new to all this stuff.

Just googled to find some ideas about installing ypserv and ypbind and portmapper. We did all that and also started them successfully. But now the clients are not able to join to the NIS domain . The error log states "YP_DOMAIN NOT BOUND".

I guess we have not entered the /etc/yp.conf, /etc/hosts files properly. Please let us know the detailed steps to setup a NIS server .

Also, please let us know what entries should go into the different /etc/<file_names>? What is meant by HOSTNAME in the /etc/hosts file?

Is there any other files which need to be changed? Are we missing any steps?

Also to add-on, while executing the ypinit command we faced the following error:

At this point, we have to construct a list of the hosts which will run NIS servers. localhost.localdomain is in the list of NIS server hosts. Please cont inue to add the names for the other hosts, one per line. When you are done with the list, type a <control D>. next host to add: localhost.localdomain next host to add:

The current list of NIS servers looks like this:

Is this correct? [y/n: y] y

Error running Makefile.

View 3 Replies View Related

Server :: PHP Installation On Centos Server - Error: Mysql Configure Failed

Nov 19, 2010

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.

View 6 Replies View Related

CentOS 5 Server :: What Is Configure Option Of Mysql Server From Repo?

May 6, 2010

what is configure option of Mysql server from Centos repo? I mean configuration option used before compilation.

View 1 Replies View Related

CentOS 5 :: Error: Mysql Conflicts With Mysql-server-community

Jun 4, 2009

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

View 16 Replies View Related

CentOS 5 Server :: Put A MySQL Database In A Server's Memory?

Mar 18, 2010

I'm looking for a way to put a MySQL database in a server's memory. The disks aren't fast enough to keep up with the usage and I don't feel like going for a splitted web&db server yet because of the costs.

Because this involves risks (unless there's a way to read from the memory and write to the memory AND disks?), so I'd prefer that the DB gets copied automatically every hour or so to the local disks.

View 1 Replies View Related

CentOS 5 Server :: MySQL On Cent OS 5.2, Error In MySQL

Mar 3, 2009

I just configured a complete Cent OS 5.2 system for use as a web server. I can configure Apache and PHP but MySQl seems to be causing some issues -

[mysqld]
datadir=/var/lib/mysql
socket = /var/lib/mysql/mysql.sock
user=mysql
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).

[Code]...

View 16 Replies View Related

OpenSUSE :: How To Setup A Mysql Server

Dec 11, 2010

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 Replies View Related

Ubuntu Installation :: 10.10 Server And MySQL Setup

Dec 17, 2010

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 Related

Server :: Setup An Incoming And Outgoing Mail Server On Centos?

Feb 22, 2010

What is the easiest way to setup an incoming and outgoing mail server on centos? Without using a control panel, such was webmin.

View 2 Replies View Related

Software :: Get An X Window Server Setup On My CentOS 5.3 Server Rack?

Jan 5, 2010

I am trying to get an X window server setup on my CentOS 5.3 server rack. I have gotten as far as to doing:

yum groupinstall "X Window Sever" "GNOME Desktop Environment"

EDIT-Forgot to mention that I did Xorg -configure before testing the config. Only errors I got were:

(EE) LoadModule: Module ati_r500 does not have a ati_r500ModuleData data object.
(EE) Failed to load module "ati_r500" (invalid module, 0)

[Code]...

Linuxquestions--I posted this over on the CentOS forums, which are not as booming. Then I remembered these forums for when I had my VPS way back when and you guys were pretty helpful, of course expected me to mostly do my own reading which I dont mind its just having a hard time understanding some of the things in what I was reading. I even believe I came here with this problem before but abandoned the issue because my VPS was not powerful enough or something of the sort, but this was many years ago also on CentOS using apt. Now using yum which I like much better.

View 3 Replies View Related

CentOS 5 Server :: Email Server Setup Using Sendmail And Dovecot?

Apr 24, 2009

I am trying to set up a mail server on centos5 using sendmail and dovecot, and eventually spamassassin and some antivirus filter as well. I'd also like to get the proper secure auth mechanism set up at some point too. But for starters, I've been having a lot of difficulty trying to even connect to the mail server from a client computer in the local network. I installed Eudora on the client and after some tweaking in dovecot I was able to connect to the mail server, but then when I try to send an email I get a "connection refused" error, with nothing being logged on the server that I can see.

The last time I set up a mail server was Fedora Core 2, so the configuration files have changed a bit to say the least, and I can't really refer back to those to set up this new server. Does anybody know of a good step-by-step doc on getting the mail server going? I've read the man pages and other various readme's, but these really only list out the available options with no really good explanation of what needs to be done to get the mail server going. If there isn't a full write-up on how to do this, I'll put something together when I'm finished so others can use it in the future.

View 7 Replies View Related

CentOS 5 :: Easiest Way To Mirror Existing Server Setup On A New Server?

Jan 13, 2011

We have two CentOS 5 servers in production (web and database). We are setting up a single staging server that will mirror the configurations of these servers as closely as possible. What is the easiest way to ensure the exact same software and configs as the production servers are setup on the new staging server. Our contracted data center provider has already informed us that they do not perform images and NO we do not have physical access to the machines. It is undetermined whether we will be virtualizing the staging server into two virtual servers yet, so for the purposes of this post lets assume we are not. I'm seeking a faster/more precise method than doing this by eye and hand.

Some information on our web server code...

View 4 Replies View Related

Server :: How To Reset Root Password Of MySQL?

Sep 21, 2010

for resetting the root user's password. Actually, I am using www.linuxzoo.net for online practice of Linux and have MySQL installed on it. But I forgot the password I set. There was no password by default set for the root user. So, I just trying setting a password last week. Now I am not getting what I did.

View 13 Replies View Related

Server :: Setup Master / Master Mysql In HA Setup Without Use Of Load Balancer Provided By Host?

Mar 31, 2010

I 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 Related

Server :: Centos Virtual Server Mail Setup ?

Nov 3, 2010

I just recently purchased a vs from a company and i am trying to set up a web site on it with kloxo and set up the mail for it upon setting up the mail settings it says:

"It is very essential that you set the my name to a properly resolvable hostname, since otherwise, many public mailservers like hotmail will reject mails from your server"

Now this is my first time setting up a vs before i have set up linux vm's to get email access but that was about a year ago.

View 6 Replies View Related

General :: LAMP Server Setup - MySQL - PHP - Apache - FTP

Mar 16, 2010

Good 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

View 1 Replies View Related

Server :: Setup A Database Using Mysql - Always Get A Connection Refused Error

Mar 2, 2010

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?

View 4 Replies View Related

Debian Configuration :: MySQL Server Gives 'Wrong Password' Error?

Mar 5, 2011

At the moment I am having a problem with the MySQL server on my VPS. It's a completely fresh install of both Debian 5 and MySQL but the problem is upon logging in I get:

[root@boris ~]#mysql -u root -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

[code]....

View 8 Replies View Related

Fedora Installation :: Change The Root Password Of MYSQL Server

Mar 16, 2009

How can I change the root password of MYSQL server. I have just finished installation, but I mistakenly typed the wrong root password, and now I need to change it from command line, because I cannot even access the UI.

View 8 Replies View Related

Server :: CentOS Ldap Server Setup

Jul 11, 2011

I am currently involved in setting up an openldap server on a CentOS platform. I am having some issues with getting it set up to the point that I can remotely manage the server via phpldapadmin in a web browser. I am running into an issue when starting the slapd daemon.

See the output below to better understand:

View 7 Replies View Related

Server :: Nagios Server Setup In Centos 5.3

Aug 13, 2010

I have installed the nagios by FAN 2.0 CD. In this distro all the required softwares are bundled. Now i do not know where to start. How can i monitor my other server on the network. I have google on the internet but it is not giving the clear idea. Is there any document on the net or how to which can show that how to configure nagios with centreon or originally from changing nagios files.

View 6 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved