Solved

mysql setup

Posted on 2011-09-14
4
478 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
  • 2
  • 2
4 Comments
 
LVL 76

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 76

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

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
The purpose of this article is to demonstrate how we can use conditional statements using Python.
Learn how to get help with Linux/Unix bash shell commands. Use help to read help documents for built in bash shell commands.: Use man to interface with the online reference manuals for shell commands.: Use man to search man pages for unknown command…
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.

758 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now