Solved

mysql setup

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

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 77

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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Which Linux flavors will this run on? 6 76
nagios monitor 3 41
update joined tables 2 26
RDBMS and No sql database 4 38
I. Introduction There's an interesting discussion going on now in an Experts Exchange Group — Attachments with no extension (http://www.experts-exchange.com/discussions/210281/Attachments-with-no-extension.html). This reminded me of questions tha…
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…
Learn several ways to interact with files and get file information from the bash shell. ls lists the contents of a directory: Using the -a flag displays hidden files: Using the -l flag formats the output in a long list: The file command gives us mor…
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…

930 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

10 Experts available now in Live!

Get 1:1 Help Now