Solved

mysql setup

Posted on 2011-09-14
4
491 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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
This article shows the steps required to install WordPress on Azure. Web Apps, Mobile Apps, API Apps, or Functions, in Azure all these run in an App Service plan. WordPress is no exception and requires an App Service Plan and Database to install
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…
Connecting to an Amazon Linux EC2 Instance from Windows Using PuTTY.

724 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