how to set up mysql database on local machine

[lukemersh]

please can somebody tell me how to set up a mysql database on a local machine?

[john_hudson]

Not sure what you mean; if you mean start using mysql, then
mysql -u root
will get you started but you then need to give yourself a root password, remove the anonymous users, add normal users and grant them privileges. There are various threads on these issues and there is info mysql to consult.

If you mean you want to move an existing mysql database to your local machine, the easiest way is to back it up with mysqldump and then start mysql as described above and enter
source <filename>
If you have backed up all the databases on the other machine including the user database, you will find that all the other users and their privileges have been transferred at the same time. Then you need to
flush privileges;
and you will effectively have a clone of what was on the other machine.

[lukemersh]

ok i tried that 'mysql -u root' and got ' (ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (2))
any ideas?

[hendersj]

On Wed, 16 Mar 2011 19:06:02 +0000, lukemersh wrote:

> ok i tried that 'mysql -u root' and got ' (ERROR 2002 (HY000): Can't
> connect to local MySQL server through socket '/var/run/mysql/mysql.sock'
> (2))
> any ideas?

Try starting the daemon.

sudo /etc/init.d/mysqld start

You might want to do some reading at http://dev.mysql.com/doc/ to learn
how to use the product.

Jim



--
Jim Henderson
openSUSE Forums Administrator
Forum Use Terms & Conditions at http://tinyurl.com/openSUSE-T-C

[lukemersh]

On Wed, 16 Mar 2011 19:06:02 +0000, lukemersh wrote:

> ok i tried that 'mysql -u root' and got ' (ERROR 2002 (HY000): Can't
> connect to local MySQL server through socket '/var/run/mysql/mysql.sock'
> (2))
> any ideas?

Try starting the daemon.

sudo /etc/init.d/mysqld start

You might want to do some reading at MySQL :: MySQL Documentation: MySQL Reference Manuals to learn
how to use the product.

Jim



--
Jim Henderson
openSUSE Forums Administrator
Forum Use Terms & Conditions at openSUSE Forums FAQ

tried that and got:
@linux-qc6t:~> sudo /etc/init.d/mysqld start
root's password:
sudo: /etc/init.d/mysqld: command not found

[hcvv]

Have you installed it? It is difficult for us to guess what you did, what you did not, what you allready read/studied and what not when you talk to us in one and a half line messages.

[lukemersh]

Have you installed it? It is difficult for us to guess what you did, what you did not, what you allready read/studied and what not when you talk to us in one and a half line messages.

im sure i have installed it via yast. maybe i should download it manually??

[hcvv]

Why download manualy? I only asked if you have installed it. Do not try to make it more difficult as it is.

When you have installed it (either using YaST or zypper), you could go to YaST > System > System services (runlevel). Look there for mysql in the llist and change it to yes. This should start the daemon (and also on boot).

[lukemersh]

cool, you was right, it wasnt on doh...

[robin_listas]

On 2011-03-16 21:06, lukemersh wrote:

> sudo: /etc/init.d/mysqld: command not found

No final 'd'. Or "rcmysql start", as root.

--
Cheers / Saludos,

Carlos E. R.
(from 11.2 x86_64 "Emerald" at Telcontar)