Solved

mysql setup

Posted on 2011-09-14
4
488 Views
Last Modified: 2013-12-16
hello there,
I installed the same version of mysql yesterday on my server and today im trying to do the same thing for a server running on Centos v5.6
whats the issue here because its a fresh install but its not letting me set a password or start it..
[(08:04 PM)][(root@alpha)] [(~)] $ /opt/mysql5158/bin/mysqladmin version
/opt/mysql5158/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: YES)'
[(08:04 PM)][(root@alpha)] [(~)] $ /opt/mysql5158/bin/mysqladmin -u root password 'temp123'
/opt/mysql5158/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: YES)'
[(08:04 PM)][(root@alpha)] [(~)] $ /opt/mysql5158/bin/mysqladmin --defaults-file=/opt/mysql5158/etc/my.cnf shutdown
[(08:04 PM)][(root@alpha)] [(~)] $ /opt/mysql5158/etc/mysql.server start
Starting MySQL.Manager of pid-file quit without updating fi[FAILED]
[(08:04 PM)][(root@alpha)] [(~)] $

Open in new window

0
Comment
Question by:XK8ER
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 78

Accepted Solution

by:
arnold earned 500 total points
ID: 36540345
The option for password --password='password' or -ppassword

/opt/mysql5158/bin/mysqladmin -u root --password='temp123'

to install mysql on centos, all you have to do is run yum install mysql.


did you run mysql_install_db?
what are you trying to do with mysqladmin?
mysql -u root -ptemp123.
Did you actually set the password for root?
try mysql -u root
0
 
LVL 1

Author Comment

by:XK8ER
ID: 36540479
when I run the mysql like this it works.
/opt/mysql5158/bin/mysqld_safe --defaults-file=/opt/mysql5158/etc/my.cnf

I was able to login with phpmyadmin and import the database and the website is able to communicate..
when I shutdown the running safe mode mysql and try to start it like this

/opt/mysql5158/etc/mysql.server start

this is what I get
110914 22:19:03 mysqld_safe Starting mysqld daemon with databases from /opt/mysql5158/data
110914 22:19:03 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
110914 22:19:03 [Warning] '--log_slow_queries' is deprecated and will be removed in a future release. Please use ''--slow_query_log'/'--slow_query_log_file'' instead.
110914 22:19:03 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
110914 22:19:03 [Note] Plugin 'FEDERATED' is disabled.
110914 22:19:03 [Note] Plugin 'InnoDB' is disabled.
110914 22:19:03 [Warning] Storage engine 'SPHINX' has conflicting typecode. Assigning value 42.
110914 22:19:03 [ERROR] Unknown/unsupported table type: innodb
110914 22:19:03 [ERROR] Aborting

110914 22:19:03 [Note] /opt/mysql5158/libexec/mysqld: Shutdown complete

110914 22:19:03 mysqld_safe mysqld from pid file /opt/mysql5158/data/alpha.site.net.pid ended

Open in new window

0
 
LVL 1

Author Comment

by:XK8ER
ID: 36540486
okay, I found the problem.. all i had to do was remove the /etc/my.cnf
0
 
LVL 78

Expert Comment

by:arnold
ID: 36540681
/etc/my.cnf is usually where teh configuration file is usually located, you could link
ln -s /opt/mysql5158/etc/my.cnf /etc/my.cnf
0

Featured Post

Webinar: Aligning, Automating, Winning

Join Dan Russo, Senior Manager of Operations Intelligence, for an in-depth discussion on how Dealertrack, leading provider of integrated digital solutions for the automotive industry, transformed their DevOps processes to increase collaboration and move with greater velocity.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SSH setup on ASA 5505 17 56
simple bash script needed to unpack tar.gz 4 31
Group By Function Required in PDF Output 21 38
DB2 9.7 Grant Execute SP 4 20
Introduction Since I wrote the original article about Handling Date and Time in PHP and MySQL (http://www.experts-exchange.com/articles/201/Handling-Date-and-Time-in-PHP-and-MySQL.html) several years ago, it seemed like now was a good time to updat…
Fine Tune your automatic Updates for Ubuntu / Debian
Learn how to navigate the file tree with the shell. Use pwd to print the current working directory: Use ls to list a directory's contents: Use cd to change to a new directory: Use wildcards instead of typing out long directory names: Use ../ to move…
Connecting to an Amazon Linux EC2 Instance from Windows Using PuTTY.

696 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question