Default Host For Mysql User
By default, mysql will create user with host as 'localhost'. Now, if I want the host is '1.2.3.4' by default, how to configure it?
View Complete Thread with Replies
Sponsored Links:
Related Forum Messages:
MySQL Forgetting User Permissions
Does anyone know what could be the cause of this issue? I located a few others over at cpanel.net that have this problem, but no solution has been found. [url] I am running a VPS server with the following: WHM 10.8.0 cPanel 10.9.1-S14304 RedHat 9 i686 - WHM X v3.1.0 phpMyAdmin - 2.9.0.2 MySQL client version: 4.1.10 mysql version: 5.0.27-standard I have a database user that needs "Super Privileges" and so this was done. However, when Cpanel is updated the user permission is reset automatically from "ALL PRIVILEGES" to "USAGE". Here's a look at the database permissions from phpMyAdmin. Code: User Host Password Global privileges Grant hello localhost Yes ALL PRIVILEGES Yes hello_ % No ALL PRIVILEGES Yes hello_ localhost No ALL PRIVILEGES Yes The user "hello" loses its "ALL PRIVILEGES" and switches over to "USAGE" if an update is triggered. Updates to cpanel, creating/removing a database/user, and updating the account password will cause the switch.
View Replies!
View Related
Mysql/user Is Marked As Crashed
I am trying to start mysql but i am getting the following error MySQL manager or server PID file could not be found! [FAILED] Starting MySQL................................... [FAILED] I checked my hostname.err file in /var/lib/mysql and this is the error message it shows. 070130 17:59:41 mysqld started 070130 17:59:42 [ERROR] /usr/sbin/mysqld: Table './mysql/user' is marked as crashed and should be repaired 070130 17:59:42 [ERROR] /usr/sbin/mysqld: Table './mysql/user' is marked as crashed and should be repaired 070130 17:59:42 [ERROR] Fatal error: Can't open and lock privilege tables: Table './mysql/user' is marked as crashed and should be repaired 070130 17:59:42 mysqld ended how I would repair that to get mysql to start again?
View Replies!
View Related
What Are Common MySQL User Permissions
I want to use something like PHPBB forums and using one MySQL user and database. Just wondering, what are common user permissions I should set for the user? I want to try to minimize any permissions that can cause big risk to the server security. Here is a full list of permissions I can grant to the user (via Webmin): -Select table data -Insert table data -Update table data -Delete table data -Create tables -Drop tables -Grant privileges -Reference operations -Manage indexes -Alter tables -Create temp tables -Lock tables
View Replies!
View Related
Host With Usernames Not User Numbers
I've been asked to update a local shops website and set them up with a new commerce site. I'm Looking for linux hosting around $10-$20 a month. This might be a funny request but I want to be able to create my own username with whatever hostI go with. Personally I use 1and1 for my own sites and its decent but I seriously hate how my username for ssh and ftp accounts are something like u334423423 or if I try to create a new username it is u334423423-newuser
View Replies!
View Related
MySQL Replication For User On Shared Server
I never did replication and do not know much about it so I figured I would ask here if anyone knows or has done it before like this. I have a user who wants me to enable replication on my server for his user. I dont like the sounds of it on a shared environment but if there is no risk to other users and its not a big resource hog I will do it. Anyway, from what I gather I have to: 1. execute: GRANT REPLICATION SLAVE ON user_main.* TO 'repl'@'ip-here' IDENTIFIED BY '4T6WjUZa'; [url] 2. Stop mysql server and Add in my.cnf: [mysqld] log-bin=mysql-bin server-id=1 slave-compressed=1 binlog-do-db=user_main start server[url] 3. execute: SHOW MASTER STATUS; we need values of colomns File and Position from output of above command[url] So my questions are: Is there any security risk? Is there significant extra resource usage? Is this even done on shared environments?
View Replies!
View Related
Mysql User Privilege Changed By Cpanel Or What
I am using Cpanel. One Cpanel account is backup. I use it to backup my database. Under mysql, I gave this account ( backup ) many priviledges. But when the backup script ran, error said that backup account can not 'lock table'. I gave "lock table' priviledge again and run the script, it is ok. But after a while, when the script ran autmatically on daily basis, it lost the 'lock table' priviledge again. I wonder if Cpanel is messing me up? What can I do about it? anyone knows?
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
Apache - Run Virtual Host As User
I've run into a wall trying to run apache with multiple websites allowing users to use FTPd to manage files. I'm running FreeBSD 7.1 on Apache 2.2.x The issue is that Apache runs as www:www but FTPd writes the files as username:client. When performing some scripts that edit back-end files, this obviously can cause errors. The data for each directory is stored in /home/username/www I looked into some apache directives I could use. I tried putting User and Group directives into the vhost configuration for each vhost, but that did not work. I even found the perchild module and it looked like it can do the job but was a bit scared and turned off by the fact that it states it is beta at the top of the page. (I cannot link to it because I do not have enough posts.)
View Replies!
View Related
Weird MySQL: User/pass Stops Working After A While
I am having a very strange problem with 2 different cPanel accounts on a server with 500-600 accounts. For some reason after a day or two the mysql username/password stops working. We have tried changing the MySQL user and the password with no success. The log does not indicate that the MySQL password was changed in any way. Only these 2 accounts are affected and this problem occurred at least half dozen times each. Again: these are two different accounts with 2 different MySQL users that after a while stop working (I am unable to determine if they stop working at the same time b/c they belong to different customers). When we reset the user (with the same pass) it works for a day or two. I have checked to connect not only from PHP but also from shell when it's down: it also doesn't work so this is a pure MySQL problem. Also on the server we have Fantastico.
View Replies!
View Related
Granting MySQL Command Line Permissions To A User
Is there any safe way to grant command line permissions to a user/specific account? One that only allows them access to databases on their account. The problem is that this user intermittently runs queries that cause their database to hang (including PHPMyAdmin, so they can't view the processlist through there), and I have to manually kill that process, because they can't. Server is 2.4.21 with MySQL 4.0.27, admin is cPanel WHM.
View Replies!
View Related
Better Mysql Host
my site is mainly based upon mysql ...mean I need to insert 25-30 mb data everyday .I saw several webhost saying 5 gb space ...does it mean i can store 4.5 gb data in mysql ? lets take that i will use only 0.5gb to store file&codes.
View Replies!
View Related
Best ColdFusion Host W/ MySQL
I've been with CystalTech for a while now. They're descent, but expensive. I've been hearing a lot of good things about HostNexus. A friend is recommending intermedia, but they don't offer MySQL. This is for mission critical stuff, but I can't afford dedicated. The stats don't justify it to the powers that be.
View Replies!
View Related
Mysql And Ms Sql Host
I am trying to find a reliable host that can provide both mysql and ms sql for the same site. I know this is not how the site should be designed, and a complete redesign is in the works to streamline everything to mysql, but for now I need a host that can provide both. Our current host is absolutely horrible (seekdotnet.com) as there is an excessive amount of downtime (typically a few times/day for various periods of time). Thus far the only one I have been able to find is Mosso, but it seems a lot of people on here are anti-mosso, or have had problems with mosso.
View Replies!
View Related
Best Host For ASP/PHP/mySQL
My current web host (SectorLink) has been acting flaky lately so I'm in the market for a My requirements are at least 6GB of space, the ability to run multiple websites on the same account (I'm currently at 7) and ASP, PHP, and mySQL capabilities. I'd also like the price to be competitive with what I'm currently paying ($11/month) though I'm willing to go up a bit. I'm currently looking at 3 hosts, but I'm open to any suggestions. My short list right now includes: HostGator - Not a Windows host, I know (though they're working on Windows plans), but they do offer ChiliSoft ASP capabilities. This host would give me unlimited space and domains for $14.95 per month. AllReseller - This host would give me 50GB of space and unlimited domains for $11.95 a month. Aspnix - This host would give me 10GB of space and 7 domains for $7.77 a month. Has anyone used any of these hosts? What were your experiences with them? Could you recommend any other hosts? Side Question to any classic ASP developers out there: Have you used ChiliSoft ASP and, if so, how good is it at running scripts originally written for IIS?
View Replies!
View Related
Best Host For Legacy Php < 4.47 And Mysql <4.1.21
Looking for linux and the above, on shared or virtual plan. A number of sites will be on the account and can run sites without 'www' . phpmyadmin, real FTP's (non anonymous), SSH/SFTP access, decent uptime, spam filters and support in place. No outsourcing of support, and they house their own servers.
View Replies!
View Related
Shared Host , Reliable Mysql
I know there are a million "looking for cheap shared hosting" threads. Hopefully my particular values/interests justify a new one. I'm a (mostly PHP/MySQL/CMS) web developer, using Dreamhost for years (perhaps DH was better back then) to host staging/development sites for clients (once I've developed a client site, I usually make them get their own host somewhere more reliable), as well as for low-traffic sites, transferring files, etc. What I don't like about Dreamhost: a) SLOW. my guess is this is 25% web server overselling, and 75% MySQL server overselling. My simple sites are tolerably slow - including lightweight php/mysql sites (textpattern CMS, etc.) - BUT my Drupal and Silverstripe and ZenCart experiments are intollerable (5+ second page loads). b) funny ownership policies - I can't (easily) create a client FTP user that is restricted to one of my subfolders. Each user = exclusive file/folder ownership. c) not much else. I seem to get a-little-too-frequent DNS problems/outages, and used to get a-little-too-frequent server lock-ups... but I don't expect perfection from a cheap host. And of course I send my mail through google apps, I wouldn't trust a cheap host with my mail. What I like about Dreamhost: a) the control panel functionality. Yes, it's ugly, but god it does a lot of nice stuff that cPanel doesn't (and frankly, cPanel is usually ugly too). b) the usual: a very low price for unlimited domains, unlimited mySQL, and huge storage. So, who is my next low-cost host? a) Interested in MySQL performance/protection - perhaps hosts that put MySQL [and mail] on separate servers, like DH, but don't overload them!?! Do I need to worry about this? b) I wouldn't mind moving to a reseller account c) I'd like a progressive control panel; I have clients on medialayer - who use directadmin (nice) - but their pricing structure is a bit tight on domains/db/storage. [As an aside, medialayer provides excellent shared hosting performance/value/support, if you don't need a lot of domains/db/storage] d) I'd like to stay in the $10-20ish a month range
View Replies!
View Related
MySQL Host - Max_user_connections Exceeded
I am getting the error "max_user_connections exceeded" for database user "xxxx". So every time this happens I have to feed a new database admin login to my script. There is nothing wrong with the script since it is very popular membership script. I think my host just allows low number of "max_user_connections". please advice me on a host that allows higher number of "max_user_connections"
View Replies!
View Related
Host For Remote MySQL Connection
I have developed a desktop system that uses MySQL data. I want to use a host to access the data but my current provider only allows access to MySQL data via a web server. Can anyone suggest a host that would provide direct connection to a MySQL database?
View Replies!
View Related
Fast UK Host With MySQL Support
I currently run a website which is hosted with storminternet.co.uk and, while I can't fault their reliability, the (lack of) performance is undermining the usefulnes of the website. Key features of the website are: - completely MySQL/PHP driven so the host needs MySQL support and processor power . Some of the MySQL queries are fairly complex and call upon multiple tables of large datasets. - monthly bandwidth is much less of an issue than speed (if that's not an oxymoron) as the number of visitors is currently <250/day. - most if not all of the visitors are from the UK In terms of budget I would be willing to go £150+/year if the service was top quality.
View Replies!
View Related
Best Host For PHP, MySQL Sites
I am reading the BYO Database Driven Website Using PHP and MySQL and I am ready to play around a bit. I was wondering if anyone could recommend a quality provider with this language. I have had problems with some in the past when using Joomla so I am trying eleviate that problem from the get-go.
View Replies!
View Related
Host That Allows MySQL Backup/restore Via FTP
I need to get the h3ll away from Godaddy, fast! However, my site has a large MySQL database (200 megabytes) and it's impossible to backup or restore via phpMyadmin. Godaddy has a feature on their control panel, where you can restore/backup your MySQL database to a special diretory on your web http file space, which you can upload/download vis FTP. I use this alot. Is there any other web hosting company that offers such a feature? I haven't seen this anywhere except on Godaddy. As to why I need to get away from Godaddy: Basically what they did was, my site was getting too much traffic (even though it's still well under Godaddy's advertised limits for that plan)... so they sent me an email that says: "Your site is using too much server resources. We have moved you to a new server to protect our other customers. Please identify steps to reduce your site traffic and contact us." They moved my site to what is, apparently, a punishment area (Godaddy Hell) where all the high volume sites go. It is so extremely slow, my site might as well not exist... it is inaccessible to my visitors for all intents and purposes.
View Replies!
View Related
PHP And MySQL App To Test Host Performance
I have the hatchling plan on HostGator. Is there a PHP and MySQL open-source application where I can put up there to test its performance on running PHP and MySql applications? I want to see if there is any performance issue on this host before migrating a large ZenCart app to it. What are people's experience on HostGator running PHP and MySQL?
View Replies!
View Related
In Search For Host With Latest PHP/mySQL Versions.
I'm desperately trying to find a hosting service that offers Linux hosting with latest versions of php (5.2.x), mySQL (5.1) and maybe CVS or SVN? Space or bandwidth are not an issue (500mb space will be more than I'll ever need) This will mainly will be a development/testing place. I really need a host that actually updates to latest versions of php/mysql/apache. (not the next day the upgrade is out but some time soon at least >_<) Things like CVS / SVN, SSH access and access to change your own php.ini settings are more than welcome but I could live without.
View Replies!
View Related
Recommend A UK LAMP Host - With Some Specific Mysql Privilege Requirements
I have a moderately successful site, which makes enough money to cover my current hosting costs of 7 per month. I know, millionaire row it ain't, but it's popular. But my database is getting big and my current host wont allow the user of EXECUTE and SUPER privileges which I need to run triggers and stored procedures to keep the page load times sensible. So, I need another UK host with: - 2Gb of space (the site serves up big PDF documents) - 70Gb of bandwidth (I said they were big) - mysql privs available as above Customer service with my current host, uk web solutions, is great (apart from refusal to countenance the privileges) so I need my new host to be as good. Budget? well, you can see what I'm paying now, and I have a psychological Ă‚Â£10/month barrier which I don't want to cross.
View Replies!
View Related
Host Recommendation (Req: PHP5, MySQL, CRON, Mass-Email)
any hosts that can provide the following: PHP5.3 + MySQL CRON (to run daily/weekly scripts at a certain time) Mass Email. The scripts will send emails to a number of users(between 10-100 at first, but may grow) and this will be done daily and weekly. In the past, I've tended to go with SupaNames or FastHosts but looking at their solutions for this, it's not quite right for my requirements.
View Replies!
View Related
Reliable Shared Host Plan With PHP 5.2.+ With PDO Drivers & MySql 5.+
I switched to HostGator because they had PDO drivers enabled on shared hosting plans with PHP 5 & MySql 5. The problem is that every time they update PHP (4 times in 8 months now) they don’t include PDO in the build and its takes day to get past level 1 support and get it fixed. So I’m looking for a “Reliable” host. I had a hard time when I switched to HG finding shared hosting plans with PDO enabled.
View Replies!
View Related
Two Default Gateways
I'm trying to add a second nic to one of my servers. eth0 is connected directly to the internet on a public IP. eth1 is connected to a private network 172.16.0.0/24. When I try to add the eth1, I can no longer reach my server from the public address. The gateway for eth1 is 172.16.0.1. If I leave the gateway field blank for eth1, the server can still be reached on the public address and can also talk to clients on the lan. However, I would really like to figure out why I can't add the default gateway parameter.
View Replies!
View Related
Default Gateway
im trying to setup a vps server on one of my dedicateds, (for personal use) ive got the vps running and os installed etc but i cannot for the life of me setup networking. i have 2 ips from my datacenter but they havent given me a default gateway ip and dont seem to know what one is so does anyone know how to get the default gateways ip for a ip (the ip i have is in the 66.79.185.xxx group )
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
Apache Default Message
When i use the ip of my homepage and not the domain i see this: Quote: Apache is functioning normally How can i change it? And for lxadmin the same : Quote: This is the LxAdmin Default Page How can i change it?
View Replies!
View Related
Field 'row' Doesn't Have A Default Value
When I'm insert data through form coming following error. Field 'row' doesn't have a default value But When I'm ruing on Local host ( Local computer ) properly working. But it is not working on my server. Please visit this video File. You can see my Error.www.visionlanka.com/20081124.avi
View Replies!
View Related
Default Domain For Lxadmin
In lxadmin currently no domain is set as default domain and what would happen if I set one of the site as a default domain? What changes can be noticed and will there be any kind of effect on that particular domain?
View Replies!
View Related
|
TRACKER
