Mysql Account Access
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..
View Complete Thread with Replies
Sponsored Links:
Related Forum Messages:
Access An Account On Shared Ip Without Domain Name
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.
View Replies!
View Related
Can't Access Sub FTP Account Using Explorer
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.
View Replies!
View Related
Backup From 1 Ftp Account To Another Without Ssh Access
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?
View Replies!
View Related
How To Create An FTP Account With Limited Access
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)
View Replies!
View Related
How To Backup Host Account With Out SSH Access
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.
View Replies!
View Related
MySQL DB Access Allowed? Are There Any?
For 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
View Replies!
View Related
Mysql Access Denied
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
View Replies!
View Related
Allow Remote Mysql Access
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?
View Replies!
View Related
How To Secure Access To MySQL Database
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.
View Replies!
View Related
Fast MySql Access- Localhost
I'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?
View Replies!
View Related
MYSQL Gives Access Error After Server Move
I 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.
View Replies!
View Related
MySQL: Access Denied For Root User
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?
View Replies!
View Related
Copying (MySQL) Database Without Panel Access.
A customer would like to move his hosting from another host to me. But the other host does not want to cooperate and give me access to the panel or files. Threw the customer I did get the ftp information, and within the config file I have the database username and password. How is it possible to copy the database, without having the hosting panel access?
View Replies!
View Related
Error With Mysql While Restoring Account
I was trying to restore an account via SHH and I get this message while the process arrived at restoring databases: Quote: ERROR at line 4236: DELIMITER must be followed by a 'delimiter' character or string ERROR at line 4237: DELIMITER must be followed by a 'delimiter' character or string Done Restoring database roundcube...... /usr/bin/mysqladmin: CREATE DATABASE failed; error: 'Can't create database 'roundcube'; database exists' ERROR at line 32: DELIMITER must be followed by a 'delimiter' character or string ERROR at line 33: DELIMITER must be followed by a 'delimiter' character or string ERROR at line 76: DELIMITER must be followed by a 'delimiter' character or string ERROR at line 77: DELIMITER must be followed by a 'delimiter' character or string ERROR at line 120: DELIMITER must be followed by a 'delimiter' character or string ERROR at line 121: DELIMITER must be followed by a 'delimiter' character or string ERROR at line 163: DELIMITER must be followed by a 'delimiter' character or string ERROR at line 164: DELIMITER must be followed by a 'delimiter' character or string Done Restoring database horde...... /usr/bin/mysqladmin: CREATE DATABASE failed; error: 'Can't create database 'horde'; database exists' ERROR 1146 (42S02) at line 23: Table 'horde.turba_objects' doesn't exist ERROR 1146 (42S02) at line 24: Table 'horde.turba_objects' doesn't exist ERROR 1146 (42S02) at line 25: Table 'horde.turba_objects' doesn't exist ERROR at line 31: DELIMITER must be followed by a 'delimiter' character or string ERROR at line 32: DELIMITER must be followed by a 'delimiter' character or string ERROR 1146 (42S02) at line 66: Table 'horde.horde_prefs' doesn't exist ERROR 1146 (42S02) at line 67: Table 'horde.horde_prefs' doesn't exist ERROR 1146 (42S02) at line 68: Table 'horde.horde_prefs' doesn't exist ERROR 1146 (42S02) at line 69: Table 'horde.horde_prefs' doesn't exist ERROR at line 75: DELIMITER must be followed by a 'delimiter' character or string ERROR at line 76: DELIMITER must be followed by a 'delimiter' character or string ERROR 1146 (42S02) at line 110: Table 'horde.kronolith_events' doesn't exist ERROR 1146 (42S02) at line 111: Table 'horde.kronolith_events' doesn't exist ERROR 1146 (42S02) at line 112: Table 'horde.kronolith_events' doesn't exist ERROR at line 118: DELIMITER must be followed by a 'delimiter' character or string ERROR at line 119: DELIMITER must be followed by a 'delimiter' character or string ERROR 1146 (42S02) at line 153: Table 'horde.kronolith_storage' doesn't exist ERROR 1146 (42S02) at line 154: Table 'horde.kronolith_storage' doesn't exist ERROR 1146 (42S02) at line 155: Table 'horde.kronolith_storage' doesn't exist ERROR at line 161: DELIMITER must be followed by a 'delimiter' character or string ERROR at line 162: DELIMITER must be followed by a 'delimiter' character or string ERROR 1146 (42S02) at line 196: Table 'horde.mnemo_memos' doesn't exist ERROR 1146 (42S02) at line 197: Table 'horde.mnemo_memos' doesn't exist ERROR 1146 (42S02) at line 198: Table 'horde.mnemo_memos' doesn't exist ERROR at line 204: DELIMITER must be followed by a 'delimiter' character or string ERROR at line 205: DELIMITER must be followed by a 'delimiter' character or string ERROR 1146 (42S02) at line 239: Table 'horde.nag_tasks' doesn't exist ERROR 1146 (42S02) at line 240: Table 'horde.nag_tasks' doesn't exist ERROR 1146 (42S02) at line 241: Table 'horde.nag_tasks' doesn't exist ERROR at line 247: DELIMITER must be followed by a 'delimiter' character or string ERROR at line 248: DELIMITER must be followed by a 'delimiter' character or string Done What does this error mean and how to solve this problem? I have updated cpanel and mysql but the problem is still found This problem found while trying to restore any account not this one only..
View Replies!
View Related
Configuring Server To Handle Both MySQL And MS Access Databases
Since I have never worked on the server end of things I had a quick question for all you web hosting gurus. Is it possible to have PHP installed on ONE single server and still have the ability for the server to work with both MS Access AND MySQL at the same time? I would think YES, but I am being told by our server branch at my current job that this is not the case. They claim there is no way for the server on one machine to be able to handle both types of databases. Are they right? If they are wrong and it is possible to have one server run both type of databases, what steps would be necessary to set up the server to handle both types? Do we need to tweak the php.ini file or is there another method of allowing the server the ability to work with both MySQL and MS Access. Sorry if this question seems stupid or odd, as I said, I have minimal experience on the server end but I am confident that a server can handle both.
View Replies!
View Related
Recommend An ISP For Webspace? (need Php + Mysql + Root SSH 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.
View Replies!
View Related
Copy An Account From Another Server Via WHM - Cannot Copy Mysql Database
In previous thread we made few manual transfer of our domains. We also made some automated migration of few domains/sites using Web Host Manager's Copy an account from another server feature. All the files and other settings were properly transferred from old server to new server, but only the mysql database is not visible on new server. I am unsure if the same got copied to new server.
View Replies!
View Related
IIS 5 - Cant Access Page From IE7 But Can Access From Firefox
I found a great little app called ID Shutdown Manager which bascially lets you do stuff like wake on LAN, Shutdown, Log Off etc. The App also has a cgi script which you can call from a web server so you get a web interface to the program. This is exactly my reason for getting the app as I just wanted to host a web page where I could login from the internet and wake on lan my media PC. Ok so... The app gives you all the iis or apache setup instructions and tells you to place the cgi script which is actually a .exe into the scripts folder and then enable basic authentication for it. Done. So if I navigate to <SERVER>/scripts/sdmancgi.exe its supposed to give me a user / pass prompt and then when login successful I see the app and can wake on lan etc. ok I have got this to work on the actual machine where server is running I can access it in IE7 by localhost etc.. and it works However when I try to access from another PC in my lan by typing <SERVER>/scripts/sdmancgi.exe I get a nice little message saying the content cannot be displayed you may require to insall a program or something to display it. If I try to access the page from firefox on same remote PC, it works! I can also access page from outside my LAN, it works on my N95 browser. Also I have had friends try it from firefox from the Internet and they say it works as well. Forgot to mention I am running on port 8081 as I already have other servers running on 8080 and 80 (one is my router and the other server installed itself from setup.exe and I dont know what server its using) I have also tried latest apache server as well as some other free one. Both have the same effect. Ok in firefox, not in IE. One would think its a problem with the cgi file not compatible with IE7 however, I even tried to go to default page setup in IIS <SERVER>:8081 and I get the same message. So at this point the server hasnt even tried to access CGI or prompt for Basic Authentication. I tried googling and not much luck. I read something about CSS and when I view source of failed web page from IE7 it mentions something about CSS so dont know if this is it?
View Replies!
View Related
Can't Access Dns Only Remote Access Key
I have successfully installed dns only to my vps. the problem is when i try to add it to the cluster system on my other vps it asks for a remote access key, so i visit both ip:2087/scripts/setrhash and ip:2086/scripts/setrhash and it shows an unable to connect error in firefox. this is both using [url] does anyone know how i can access the remote access key?
View Replies!
View Related
Existing Account Have Enabled Catch All Account
existing account have enabled catch all account automatically & i don't know how? Main >> Server Configuration >> Tweak Settings Default catch-all/default address behavior for new accounts. "fail" is usually the best choice if you are getting mail attacks. currently it is tick marked on fail And forwarders has been set to e.g jeetu@jeetu.info to domain automatically & also i don't how? when i try to delete this forwarder its shown deleted successfully Code: Email Forwarding Maintenance jeetu@jeetu.info's mail will no longer be redirected to jeetu. then again i checked forwarder & found that forwarder is not deleted why? what could be the problem? due to this our clients are facing out of disk space running problem & they are not able to get future emails 1. now i want to disable catch all account for all existing accounts at one go 2. also i want to terminate forwarders for all existing users at one go Let me know how to do this Check attachment for further reference
View Replies!
View Related
Installed MySQL In /usr/local/mysql But Error In /var/lib/mysql
I installed the MySQL binary packages in /usr/local/mysql/ after removing the MySQL RPM package. MySQL is functioning when I executed /usr/local/mysql/bin/safe_mysqld. I reinstalled MySQL before I installed PHP. When I used a PHP script to access a MySQL database, it outputs an error: Code: Warning: mysqli::mysqli() [function.mysqli-mysqli]: (HY000/2002): can't connect to local mysql server through socket /var/lib/mysql/mysql.sock in index.php on line 2 However, I installed MySQL in /usr/local/mysql, not in /var/lib/mysql. How do I fix MySQL?
View Replies!
View Related
How Do I Secure Remote Access To Remote Access Products
I have windows servers that I'll be co-locating very soon. I have purchased a Dell 2161ds-2 and an APC remote boot power strip. Could someone please tell me the best way to secure remote access to these products. Do I put them on public IP's and allow them through the firewall or do I put them behind the firewall and access them after I authenticate through the firewall.
View Replies!
View Related
How To Restore Mysql Databases From /var/lib/mysql/user_database/ Files Only
I recently had a harddrive failure and luckliy I can still access certain directories on this failed drive. I can still access the /var/lib/mysql/ directory which holds all the users databases and have backed all these up separately using tar. Now what I need to know is how do you restore these database files to another server? I tried simply untar'ing one of these to the new servers /var/lib/mysql/ direcotry and it stuffed Mysql up - it went offline. I had to get a cpanel tech to bring Mysql back online. how can I get these database files to fully work on a new server?
View Replies!
View Related
Can I Move /var/lib/mysql To /home/mysql
my /var partition is full, im not sure if any files i can remove to get more free space on /var partition. because there are more free space on /home, i think if i can move all the /var/lib/mysql to /home/mysql, if yes,howcan i move it and do any change, can let the sql data do not lose, andrun well in the feature ?
View Replies!
View Related
MySQL Monitor Shows MySQL As Offline When It's Not
I've been racking my brains with this problem for the last couple of months and have made zero progress. I've asked a lot of people if they know what might be wrong here, but none of them have any idea. Basically, the problem is that any sort of service monitor I put on my server shows MySQL as being down/offline, even when I know for sure it's up and running perfectly fine. All other services report a green light. The mysqld service is running on port 3306, which is open both inbound and outbound on my APF config, so as far as I can tell it's nothing to do with the firewall (I won't rule that out though). The other odd thing is that MySQL shows a green light within WHM, but not anywhere else. Does anyone know what might be wrong here? Am I missing something entirely fundamental and obvious?
View Replies!
View Related
Difference Between --with-mysql And --with-mysql=dir
I am not sure what difference between --with-mysql and --with-mysql=/usr to compile php 4.4.7 because I get error message when I use --with-mysql=/usr the error message is like Mysql header can not be found or similar thing. it ok when I use --with-mysql so, I am afraid that can I use php and mysql without problem by using --with-mysql?
View Replies!
View Related
Uninstall MySQL 3.23 And Install MySQL 5.0
I've rented a dedicated server that comes with Red Hat Enterprise Linux 4 and MySQL 3.23 but I need at least MySQL 4.1 or higher. My knowledge about GNU/Linux is very limited, so I've read some documents at mysql.com and now I think I have to follow these steps: 1. Uninstall MySQL 3.23 with this command line: shell> rpm -e mysql-*.rpm 2. Install the server and client RPMs of MySQL 5.0: shell> rpm -i MySQL-server-VERSION.i386.rpm shell> rpm -i MySQL-client-VERSION.i386.rpm
View Replies!
View Related
MySQL Error : MySQL Server Has Gone Away
I keep getting this error : MySQL Error : MySQL server has gone away How do I fix it? my.cnf contents Quote: [mysqld] safe-show-database old_passwords back_log = 75 skip-innodb max_connections = 800 key_buffer = 48M myisam_sort_buffer_size = 64M join_buffer_size = 1M read_buffer_size = 1M sort_buffer_size = 2M table_cache = 3000 thread_cache_size = 128 wait_timeout = 90 connect_timeout = 30 tmp_table_size = 128M max_heap_table_size = 64M max_allowed_packet = 256M net_buffer_length = 16384 max_connect_errors = 10 thread_concurrency = 4 read_rnd_buffer_size = 786432 bulk_insert_buffer_size = 8M query_cache_limit = 3M query_cache_size = 48M query_cache_type = 1 query_prealloc_size = 262144 query_alloc_block_size = 65536 transaction_alloc_block_size = 8192 transaction_prealloc_size = 4096 default-storage-engine = MyISAM max_user_connections = 500 [mysqld_safe] nice = -5 open_files_limit = 8192 [mysqldump] quick max_allowed_packet = 16M [myisamchk] key_buffer = 64M sort_buffer = 64M read_buffer = 16M write_buffer = 16M [mysqlhotcopy] interactive-timeout
View Replies!
View Related
Access
I cannot access to [url](our Hosting provider). Can you access the website? I disabled my static IP by contacted my ISP and tryed to access it with different IPs. But I can access to other web sites. This problem occurred when I installed Boldchat operator with together Microsoft .NET Framework. Most times my modem settings broke because of this software. So I removed it from my computer. But I still cannot access to the web site. But I can access it by using anonymous surf sites such as [url] My ISP could not found a problem.
View Replies!
View Related
Access To Liquidweb From EU
Hello everyone, i would like to know if the forum has users from Europe and that they have dedicate server at Liquid Web. I have few dedicate servers at liquidweb and in past 12 months I have big problems with speed with these servers, and with speed to them. Speed download / upload sometimes does not exceed either 512 Kbps and sometimes download or upload from liquidweb server can be only 10 kB/s. Loading of some pages can take for 1 minute. I opened a ticket for this problem, but the Support feedback told me that this is quite normal for my distance which I consider totally unacceptable. It is acceptable that the ping must be large, but low speed is simply unimaginable.
View Replies!
View Related
|
TRACKER
