|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
|
|
|
Stay one step ahead of the competition. Evaluate and give feedback
on some of the hottest web development tools on the market today.
Make your opinion heard! Click
Here
|
|
#1
|
|||
|
|||
|
Pls help: MySQL installation without root permission
Hi,
is it possible to install RPM or binary files (whats the hell are the differences between them?) on a different directory (not into the standart /usr/local...) to a directory on a shared hosting without having root permission? So i want specially install it on my directory, where i my website is hosted by a hosting firm. Shell access is given but only user permissions, not root. Is it possible and what kind of file do i have to install from mysql.com? My hosting firm has hosted package including mysql databases and i have paid for it. But after a week they limited the query limit to 3600 query in a hour. This restriction is definitely to low. They wont change it and so i have to go my way. I have installed it but when i change the configure files with this command line: ./configure --with-tcp-port=3309 --with-unix-socket-path=/www/mysite/htdocs/mysql/mysqls/tmp/mysql.sock --prefix=/www/mysite/htdocs/mysql/mysqls i get such error: Code:
NOTE: This is a MySQL binary distribution. It's ready to run, you don't
need to configure it!
To help you a bit, I am now going to create the needed MySQL databases
and start the MySQL server for you. If you run into any trouble, please
consult the MySQL manual, that you can find in the Docs directory.
Installing all prepared tables
Fill help tables
To start mysqld at boot time you have to copy support-files/mysql.server
to the right place for your system
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
./bin/mysqladmin -u root password 'new-password'
./bin/mysqladmin -u root -h toptip password 'new-password'
See the manual for more instructions.
NOTE: If you are upgrading from a MySQL <= 3.22.10 you should run
the ./bin/mysql_fix_privilege_tables. Otherwise you will not be
able to use the new GRANT command!
You can start the MySQL daemon with:
cd . ; ./bin/mysqld_safe &
You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory:
cd sql-bench ; perl run-all-tests
Please report any problems with the ./bin/mysqlbug script!
The latest information about MySQL is available on the web at
http://www.mysql.com
Support MySQL by buying support/licenses at https://order.mysql.com
Starting the mysqld server. You can test that it is up and running
with the command:
./bin/mysqladmin version
041201 17:32:22 [Warning] Asked for 196608 thread stack, but got 126976
041201 17:32:22 [Warning] Asked for 196608 thread stack, but got 126976
And if i want to start with: Code:
cd . ; ./bin/mysqld_safe & this error comes up: Code:
Starting mysqld daemon with databases from /www/mysite/htdocs/mysql/mysqls/data STOPPING server from pid file /www/mysite/htdocs/mysql/mysqls/data/hosting.pid 041201 17:55:53 mysqld ended I'm waiting for helpful assistance. Thanks |
|
#2
|
|||
|
|||
|
Check the user rights for the directory you are in.
The directory should be owned (or have rights for) your mysql user and/or group possibly even your own user. Try to change the ownership to mysql. That usually helps. |
|
#3
|
||||
|
||||
|
You likely can't run the RPM as the RPM usually tries to create accounts and use admin commands...
You could try installing from source perhaps? But some systems might not allow running a daemon from your home directory. It might be easier to have your system administrator do it for you [in other words, just get root access] |
![]() |
| Viewing: Dev Articles Community Forums > Databases > MySQL Development > Pls help: MySQL installation without root permission |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|