I run a shared hosting
OS:centos with whm/cpanel
and would like to restrict access to mysql database
example:
username:user1 created database:user1_db1,user1_db2 etc..
and can only access his own databases
so user2 can't access user1_db1.db2 etc.. and user1 can't access user2_db1,db2 etc..
Actually I make backup in 1 ftp account, also I have another ftp account what I don't use it. Do you know how to copy files directly from 1 ftp account to another one?
1 ftp account it's with bqbackup.com
1 ftp account it's with another backup provider
any of them have ssh access, so I'm looking to something like copy-at-the-fly ftp? without downloading all first to another server?
I have a few domains that I recently migrated to cPanel.
I created a 2 ftp accounts on one domain and (example bill@site.com and john@site.com), both accounts can be accesed using ftp clients, and also from Opera browser with this info:
ftp://site.com:21/ or ftp://server-ip:21/ - username bill@site.com or john@site.com and passwords.
But, this accounts can not be accessed using Internet Explorer, and my customer only uses IE , the error I recieve is something like this:
Code:
FTP Directory Error
Windows does not have access to that folder. Make sure the name of the directory was written ok and you have permission to access that directory.
Details:
The connection with the server was reset
I already tried restarting pure-ftpd, flushing the firewall rules, and there problem stills..
Im using RHES 4 + lastest kernel 2.6 and the latest release version.
I want to create a special FTP account as such:
- The user would only be able to view and upload to one directory, such as mysite.com/images/
- The user would only be able to upload .jpg files, no code/php/html or anything, just jpg pictures.
- There would be a limit of upload. (ie. only 50 MB of upload per day)
- The user would only be able to delete the files that he uploaded. (or the user would only be able to view the files he uploaded)
I have an account on an older server. Its plesk.
But now that I pointed the domain I can no longer access the old server from the web.
So this is my shared ip:
66.235.201.136
Now there are about 10 domains on the IP.
what would my URL look like to access one of those accounts in plesk in the browser?
66.235.201.136/~rgratitu
I've tried the above and it doesn't work.
...and has been for several hours now.
Somehow, I am not filled with confidence.
I am moving hosts and my old host is unable to backup my current site and give me a single tar or zip
file of my websites (They do not use cpannel)
The only access I have to them is var ftp and there custom control pannel, I have been backuing up.
My new cpanel host has given me SHH access and I was trying to
run a ftpsync a perl based script to sync a site but it times out "421 No Transfer Timeout (900 seconds)"
At the moment I am backing up the site to my local pc but it has been running for the last 12 hours, All the sites only total about 350mb but they are made up of lots of small files and I think that this is the reason why it is taking so long.
I wanted to know if any one had any other ideas as I am a little bit worried that I might lose some data that is why I would like to some how backup my old host direct to my new host.
any idea if search engines have access to our hosting account and can see which country the files are uploaded?
View 1 Replies View RelatedFor window hosting are there any that offers sql db external access without ip limit?
I've seriously requested thought the forums and actually signed up with few but all of em are either offered it but not anymore(security issue) or not even offering at all.
If you have any experience with hosting company that actually does offer sql db external access please share please!
vps nor dedicated servers are not my choice unfortunatley
and i don't think there's any free hosting that offers this. 99% freehostings use localhost
I've setup a mysql user and assigned a password for it. When I try logging in to it with
Quote:
mysql -u USERNAME -p
and then providing the password I get an error:
Quote:
ERROR 1045 (28000): Access denied for user 'USERNAME'@'localhost' (using password: YES)
I don't have trouble logging in as root and when I check the user table there, the password assigned to the user is same as the value the mysql function PASSWORD gives me. Really driving me nuts here, why is it telling me the password is wrong when it's not?
I've tried: Restarting mysql
setting new password
changing username
Using mysql server 5.1.34
I have a Ubuntu Lamp server setup in my building which is used for development purposes.
So I also have phpmyadmin setup and am using a Mysql Query browser and Mysql Administrator desktop programs to administor the database on the server. However I am not able to connect to the server from my desktop. I am able to login to my myphpadmin but not able to login via the Mysql Query Browser program.
Hopwing someone can help. I have read about port forwarding and also read a post about editing the my.cnf file on the server and changing the Bind-Address= 127.0.0.1 to the actual hostname but before I start editing the actual configuration files on the server I want to see if their is another way as I am worried that if I change the me.conf file that the phpmyadmin may stop working?
Can anyone tell me which hosting allow remote access of mysql?
View 10 Replies View RelatedI have subscribed an account in Powweb but since the Powweb does not allow MySQL remote access I need to find another hosting that allow MySQL remote access.
Wich hosting with MySQL remote access do you know?
What can I do to secure access to my MySQL database to stop it from getting compromised from hackers?
Is there any way I can restrict access to the MySQL database to my IP only?
The database is for an IPB 2.3.4 forum and the username/password are stored in a conf_global.php file that is CHMODed 0444.
how I can do to allow External Access Mysql Database on my server ? What's the procedure ?
View 1 Replies View RelatedI've been using Dreamhost for years and they're very good, but their MySql databases are quite slow. Then I moved to ServInt with a VPS, and my MySql is on localhost instead of on a different server. WOW! It's so fast!
However, now I'm trying to find a shared hosting package that has fast MySQL service.
I'm not sure if the requirement is that it's on localhost but it sure doesn't hurt.
Is there anyone who is familiar of a good solid shared hosting package with fast MySQL service?
I have a VPS with 256MB ram. i want to limit mysql memory access. suppose i want that mysql should not use more than 128MB ram.
is this possible? if yes how?
is this possible for all other services too?
how can I setup under plesk to allow a external server to access the mysql db.
View 7 Replies View RelatedI'm working with a non-profit and we're looking for an inexpensive hosting but we also need to be able to access MYSQL (port 3306) through the internet.
We use Crystal Reports and need to get to the database directly for reports.
How can change mysql root password with ssh access?
View 6 Replies View RelatedI can't find any straight answers when searching Google. I've been stuck in a what has become a nightmare server move for about 2 weeks now.
After finally getting a mysql.sock issue fixed I can get the MYSQL dbs over to the new server but it appears that their permissions need to be changed. Is there a way to handle this from the root level? I have roughly 120 dbs to process
I am moving from a VPS to a dedicated server - both have root access.
cheap-ish place to host a PROTOTYPE website. We're going to need php + mysql, but we're going to need to have more control such as root SSH access.
Here is the list of what we need to start with:
SSH access
PHP 5
Java
MYSQL 4 or 5
Apache 2
SendMail
Any ISP recommendations?
For now this is just a prototype, and it will NOT get hammered with
traffic. But we do need an outfit that is efficient and reliable.
Ship
Shiperton Henethe
We are based in the UK.
When I deleted a database, the user apparently was orphaned because when I tried to recreate it, it returned "user already exists". I've never encountered that problem although from Googling, I see others have and they delete the user to get around it.
When I log into mysql using the da_admin@ account and attempt to remove the user with drop user <user_name>; I receive the following error message:
ERROR 1227 (42000): Access denied; you need the CREATE USER privilege for this operation
It seems I don't have rights even as the root user. How can I get remove the orphaned user?
