Enable Root For Mysql
Nov 9, 2007I was wondering how to re-enable the root user for mysql?
My webhost "disabled it by default"
I am not very pleased with this, and if you are an owner of a webhost company reading this, please note that.
ADVERTISEMENT
Enable Root Password On Freebsd
Jul 15, 2007How would I go about enabling the root user on a FreeBSD 6.1 system? I've got a dedicated colocated server (hardware, not virtual) and I can't for the life of me do anything with root. I can't "su", I can't "sudo", and I can't "passwd root". I've tried different shells, etc, but nothing works. I am the server admin, but I'm doing it remotely and I just can't figure this out. I know it's not, but I'm going to ask it for the sake of it being out there anyway: Is it possible that the server lacks a root user and that I'm unable to create one?
View 5 Replies View RelatedHow To Enable Slow-query Logging In MySQL
Apr 23, 2007how to enable slow-query logging in MySQL ? Im using mysql version 4.1.20
well i just added following line in my.cnf can you please tell me is it correct way or not?
Code:
log-slow-queries=/tmp/slow_queries.log
log-update = /var/lib/mysql/updates.log
Setting Root Password MySQL
Dec 18, 2007I can't seem to get passed p21 of Database Driven Website by Kevin Yank. But I'm learning
Ive got the latest copy and and want to follow it through to see what i can learn (lots I'm sure)
Im on a mac osx and am trying to set the root password. He says to do this using terminal in the bin directory of my MySql installation.
Where is it? i know basics about getting round terminal i.e changing directories and stuff.
Change Mysql Root Password With Ssh Access?
May 29, 2008How can change mysql root password with ssh access?
View 6 Replies View RelatedRecommend An ISP For Webspace? (need Php + Mysql + Root SSH Access)
Jun 9, 2008cheap-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.
MySQL: Access Denied For Root User
Oct 25, 2007When 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?
Plesk 11.x / Linux :: Where Is Root Mysql Password
May 18, 2014i have installed phpMyAdmin becouse I don't like the limitation of db management of Plesk, but I can't find the root password to access in it. I read that Plesk rename "root" user in "admin", but I can't find the password. Where is it?
View 4 Replies View RelatedPlesk 12.x / Linux :: Enable To Create New MySQL Database Server - Test Connection Failed
May 7, 2015I freshly installed Plesk 12.0 on Ubuntu 14.04. Everything works accept the MySQL database creation.
When I try to create one, i get this error :
error: the test connection to the database server has failed because of network problems: connection refused...
Are Chained Root Ssl Certificates More Secure Than Single Root?
Nov 25, 2008I have read that although chained root ssl certificates can be more difficult to install they are actually more secure since the root certificate cannot be compromised, only the intermediary.
Is this true? It looks like both google and amazon both use chained SGC certs.
I Moved Mysql From /var To /backup/mysql, Mysql Is No Longer Working
May 8, 2009Since my /var partition is full, so I moved /var/lib/mysql to /backup/mysql/.
Seems all the files are copied and I changed my.cnf reboot mysql, but all the web sites using db is not working anymore..
Installed MySQL In /usr/local/mysql But Error In /var/lib/mysql
Jan 21, 2007I 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?
How To Enable Mbstring
Jul 5, 2009I want to enable mbstring. I googled and found --enable-mbstring is the key to turning it on but I don't know where to put this. In the php.ini?
View 14 Replies View RelatedI Need To Enable Register_globals
Jan 11, 2009i got hosting with cPanel Control panel i have some problem with this hosting because its "register_globals" disabled , i need to enable the "register_globals" on my hosting ,
View 10 Replies View RelatedClamAV - Should We Enable It?
Dec 6, 2007I would like to ask whether should we use/enable the clamAV service on our VPS? I have read from several article, it said that ClamAV is pretty hungry on CPU/Memory resources.
I would like to know, do you use/enable the clamAV on your VPS? Or even don't have it installed on your VPS?
How To Enable Csf On Start Up
Jul 1, 2009I have a VPS server, i installed and configure csf, but wonder if i reboot my server the csf would close the connection, or wont work...
so i remmeber how but i really forget and cannot remmber how to enable the csf on the vps start up..
Enable InnoDB
Jun 29, 2009how to enable innodb
use this command in mysql ....
How To Enable SSL 3.0 In WHM/cPanel
May 30, 2008My becky email client don't work with SSL 3.0 (POP3s).
by the way, when use SSL 2.0, it still can't verify certificate. I install StartCOM Free SSL successfully with every services (vps.domain.com)
[url]
How To Enable Pdo_mysql
Aug 17, 2008How do I enable pdo_mysql on my cpanel server? Can I do it somewhere in WHM or do I need to go to command line?
View 7 Replies View RelatedHow Can I Enable Gettext In Php
Mar 26, 2008i have a dedicated server with php4 and i have one client that needs to have gettext module enabled..
how can i enable it?
Mod_Rewrite (Enable It)
Mar 23, 2008I have a VPS and I need to enable mod_rewrite.
Here is my PHP Info: [url]
I read a tutorial but I just don't get it. I would appreciate if you could help me out.
I need it for my Wordpress blog.
How To Enable Fsockopen
Jun 23, 2007i use a script that needs fsockopen and curl to work. also i installed curl, but couldn't enable fsockopen. how i can do that? i'm using centos, php5, cpanel etc etc..
i looked php.ini, disable_functions is empty..
Enable ,htaccess
Oct 22, 2007i disabled the .htaccess files when i installed the modsecurity with the following command
/usr/local/apache/bin/apxs -D DISABLE_HTACCESS_CONFIG -cia mod_security.c
now how can i recompile the modsecurity with .htaccess enabled?
How To Enable Iconv
Oct 7, 2007how can i enable iconv (using .htaccess too)
View 3 Replies View RelatedEnable Soap
Jul 20, 2007Anyone know how to properly enable/compile SOAP service on a centos 4.5 / cpanel box?
View 2 Replies View RelatedHow To Enable These Functions
Aug 26, 2007My site is running with php scripts It's work fire at bluehost but get some error when i move to new VPS .
Quote:
Warning: fputs(): supplied argument is not a valid stream resource in /home/xxx/public_html/home/admin/update_categories.php on line 171
Warning: fclose(): supplied argument is not a valid stream resource in /home/xxx/public_html/home/admin/update_categories.php on line 173
Warning: fputs(): supplied argument is not a valid stream resource in /home/xxx/public_html/home/admin/update_categories.php on line 225
Warning: fclose(): supplied argument is not a valid stream resource in /home/xxx/public_html/home/admin/update_categories.php on line 227
I want to enable these functions fopen(),fputs(),fclose(),fputs(),fclose() but i don't know how to enable them .Could you tell me details
Enable Hotlinking
Aug 5, 2007I moved my website from one server to another just today and my site has a rank on another website. The ranking site lets me display my rank on my website through a hotlink to their site. When I moved my site to the new server, I can't see the image. On the old server, I could always see the image.
This is a strange issue since in Firefox, I see the image load and then it tells me the image is empty. But when I open the image's URL, I can see it just fine. I've reloaded the page over and over again, but I don't get anything. The same applies to IE.
What's even more strange is when I use a proxy, I can see the image just fine through my browser.