[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

mysql setup

Posted on 2011-09-14
4
Medium Priority
?
499 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 80

Accepted Solution

by:
arnold earned 2000 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 80

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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

In this series, we will discuss common questions received as a database Solutions Engineer at Percona. In this role, we speak with a wide array of MySQL and MongoDB users responsible for both extremely large and complex environments to smaller singl…
In this blog, we’ll look at how improvements to Percona XtraDB Cluster improved IST performance.
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses

656 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