Koozali.org: home of the SME Server

Legacy Forums => General Discussion (Legacy) => Topic started by: Tobias on March 30, 2003, 10:43:22 PM

Title: mySQL and also user webpages.
Post by: Tobias on March 30, 2003, 10:43:22 PM

Hello. I´ve spent about ten hours to sort things out about this e-smith. But since I didn´t get the mySQL database to work out my way I thought there might be some help here.

Well, I used this template to create the mySQL accounts:
(after logging in as root)
shell> mysql
mysql> GRANT ALL PRIVILEGES ON *.* TO monty@localhost
    ->     IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
mysql> GRANT ALL PRIVILEGES ON *.* TO monty@"%"
    ->     IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
mysql> GRANT RELOAD,PROCESS ON *.* TO admin@localhost;
mysql> GRANT USAGE ON *.* TO dummy@localhost;

The problem is that I don´t manage to connect from my computer using mySQL control center ([New] ERROR 2013: Lost connection to MySQL server during query). The monty account should work, as I see it. Shouldn´t it?
For further readers of this topic there is a great guide here:
http://www.mysql.com/doc/en/index.html
- - -
Webpages:
If anyone knows how to activate/reach the html accounts each individual user get. Do you have to change any settings or do I use the wrong path?www.domain.com/~user

Wold be really greateful if someone would help me out with this.
//Tobias.

Title: Re: mySQL and also user webpages.
Post by: lars on April 01, 2003, 02:11:44 AM

Install phpmyadmin ;)

That works very good for me.

// Lars
myass.dk

Title: Re: mySQL control center | lost connection during query
Post by: Tobias on April 02, 2003, 10:20:58 PM

I solved the problem myself - after aprox 20h of surfing.
===========================================
Short ver:
put "set-variable =thread_stack=1M" into /etc/my.cnf under [mysqld]
===========================================
Long ver:

What you can do, if you experience problems with your mySQL server.

I used MySQL Control Center to connect.
Each time I tried to connect I got this message in return:
- - -
[New] ERROR 2013: Lost connection to MySQL server during query
- - -

a copy of MySQL log on server shows:
- - -
Number of processes running now: 1
mysqld process hanging, pid 5026 - killed
030402 19:22:05  mysqld restarted
/usr/libexec/mysqld: ready for connections
- - -

Then you can solve this by starting putty (a program to connect and administrate another computer remotely) enter the Ip/name of server and chose SSH connection, then connect. Login as root (login as: root  
root@servername password: "your admin pass"). Then type

cd ..
cd etc
(there you should have a file named my.cnf | type dir my.* to check)
(now you have to add a string into this file.)
(use pico as editor)
pico my.cnf
(the file appears on scrn)
under the label [mysqld] add this line:
set-variable=thread_stack=1M

then save and exit. Try to connect with MySQL control center,
it should work by now. =)

//Tobias.

Title: Re: mySQL and also user webpages.
Post by: Aaron on April 21, 2003, 10:25:19 PM

I hate to barge into this thread but I had the same problem but now when I get connected I get this whats the password? or better yet how do I find the password?

Thank you,


[Web] ERROR 1045: Access denied for user: 'root@pc-00069' (Using password: YES)

Title: Re: mySQL and also user webpages.
Post by: Lars on April 21, 2003, 10:57:54 PM

The password for the MySQL root user is saved in a file called .my.cnf.

the file is here /root/.my.cnf

Hope that it helps :)

// Lars

Title: Re: mySQL and also user webpages.
Post by: Aaron on April 22, 2003, 10:18:48 PM

AH Thank you Lars

Title: Re: mySQL and also user webpages.
Post by: Lars on April 22, 2003, 11:24:23 PM

no problem

Allways like to help out where i can =)

// Lars