[SOLVED] Executing mysql

zak100 · 07-23-2012, 02:43 AM

Hi,
I have checked mysql on my system using:

Code:

whereis msysql

I got

Code:

  mysql: /usr/bin/mysql /usr/lib/mysql /usr/share/mysql /usr/share/man/man1mysql.1.gz

Kindly guide me how to execute mysql.

Zulfi.

acid_kewpie · 07-23-2012, 02:44 AM

you run "mysql"

see "man mysql" for full details of using the mysql command.

vitalstrike82 · 07-23-2012, 03:24 AM

From your post, i assume mysql is already installed in your machine.
Execute these commands

Start the server

# usr/local/mysql/bin/mysqld_safe --user=mysql &

Check if server is starting
# /usr/local/mysql/bin/mysqladmin ping

If responds on the terminal tat sqld is alive, you have successful start the server.

piyush.sharma · 07-23-2012, 03:32 AM

To start with mysql you may need to set root password or create new user.
http://www.ntchosting.com/mysql/create-user.html
This link will help you to do the stuff

zak100 · 07-24-2012, 11:53 PM

Hi,
I tried to execute mysql using

Code:

/usr/bin/mysql
ERROR 2002 (HY000): Can't connect to local MYSQL server through socket '/var/lib/mysql/mysql.sock (2)

However following command worked but it didnt recognize the user:

Code:

$ sudo /etc/init.d/mysql
password for guest:
guest is not in the sudoers file. This incident will be reported.

Kindly guide me how to create a user.

I checked the link provided above but i didnt find the command for creating user.

I also tried:

Code:

$mysqladmin
mysqladmin Ver 8.41 Distrib 5.0.67, for redhat-linux -gnu on i386
......
....
.....

Kindly guide me how to execute mysql.

Zulfi.

piyush.sharma · 07-25-2012, 12:27 AM

Command to set root password :
/usr/bin/mysqladmin -u root password 'root_password'

Create a database :
/usr/bin/mysql -u root -p'root_password' -e "create database db_name"

Create new user :
/usr/bin/mysql -u root -p'root_password' -e "CREATE USER 'user_name'@'127.0.0.1' IDENTIFIED by 'user_password';"

Grant privileges :
/usr/bin/mysql -u root -p'root_password' -e "grant all privileges on 'db_name'.* to 'user_name'@'127.0.0.1' identified by 'user_password'"

I guess, now you can create a new user and assign privileges on a perticular database.

piyush.sharma · 07-25-2012, 12:35 AM

before executing these command please ensure that mysql is running

service mysql status

if it is stopped, start it with
service mysql start

acid_kewpie · 07-25-2012, 01:55 AM

Hmm... he appears to be using an account called "guest"... doesn't bode well for getting root access to me...

zak100 · 07-25-2012, 02:17 AM

Hi,

Thanks for your reply.

I tried:

Code:

guest@HP-UX645PA ~]$ service mysql start
mysql: unrecognized service

Then:

Code:

[guest@HP-UX645PA ~]$ /usr/bin/mysqladmin -u root password
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists!

Then:

Code:

[guest@HP-UX645PA ~]$ service mysqld start
touch: cannot touch `/var/log/mysqld.log': Permission denied
chown: changing ownership of `/var/log/mysqld.log': Operation not permitted
chmod: changing permissions of `/var/log/mysqld.log': Operation not permitted
chown: changing ownership of `/var/lib/mysql': Operation not permitted
chmod: changing permissions of `/var/lib/mysql': Operation not permitted


Timeout error occurred trying to start MySQL Daemon.
Starting MySQL:                                            [FAILED]

Kindly guide me with problem.

Zulfi.

acid_kewpie · 07-25-2012, 02:22 AM

mysqld isn't installed I guess. If you're on a redhat clone, try "yum install mysql-server" however as above I'm concerned that you have no root access to this system as you're on a "guest" account.

What do you actually want to do with MySQL in the first place? You expect to use a database running on the local machine, or connect somewhere else? You seem to be just copying and pasting random commands given here to you, so some clarity on your actual goals would help everyone I think.

piyush.sharma · 07-25-2012, 02:24 AM

Sorry it was mistaken the work

try :
service mysqld status
if it is stopped then
service mysqld start

jschiwal · 07-25-2012, 02:48 AM

The program "mysql" is the client you use to connect to a mysql server. The program "mysqld" is the server program. It runs as a service, and you should have the service start when you boot.

You should download the mysql reference manual for your mysql version (run "/usr/sbin/mysqld --version" to find out your version) It has instructions on creating users, and importantly, what you need to do after installing mysql to secure it.
http://dev.mysql.com/doc/

You need to create a password for the root mysql user. Dropping the default demo database is also advisable. See section 2.10.2: "Securing the Initial MySQL Accounts"

chrism01 · 07-25-2012, 08:20 PM

As ref post#10, please tell us what distro+version you have, as this will make a difference to the cmds you require.

Code:

uname -a

cat /etc/*release*

zak100 · 07-30-2012, 01:31 AM

Hi,
I tried the cat command and I got following output:

Code:

[guest@HP-UX645PA ~]$ cat /etc/*release*
Fedora release 10 (Cambridge)
cat: /etc/lsb-release.d: Is a directory
Fedora release 10 (Cambridge)
Fedora release 10 (Cambridge)
cpe://o:fedora_project:fedora:10
[guest@HP-UX645PA ~]$

Kindly guide me.
Zulfi.

zak100 · 07-30-2012, 01:33 AM

Hi,
I also tried:

Code:

[guest@HP-UX645PA ~]$ uname -a
Linux HP-UX645PA 2.6.27.5-117.fc10.i686 #1 SMP Tue Nov 18 12:19:59 EST 2008 i686 i686 i386 GNU/Linux
[guest@HP-UX645PA ~]$

Zulfi.