Hi
i have problem with creating new mysql user
im using this code :
[PHP]INSERT INTO user (host,user,pass word,select_pri v,insert_priv,u pdate_priv) VALUES ('localhost','a bdoelmasry',PAS SWORD('341062') ,'Y','Y','Y');[/PHP]
i always get the following message:
Field 'ssl_cipher' doesn't have a default value
i tried to set NULL value for the column 'ssl_cipher' but is still have problems
Any one can help ?
18  32276 
It seems that you table has a column 'ssl_cipher' that must have a value set. It has no default and NULL is not accepted.
To determine what its data type and other things are, issue a 'DESCRIBE user' command and it will show you all columns of the table user with the following characteristics - +-------+-------------+------+-----+---------+-------+
-
| Field | Type | Null | Key | Default | Extra |
-
+-------+-------------+------+-----+---------+-------+
Ronald :cool:
Ok
what i have to do ..
to solve that ?
Ok
what i have to do ..
to solve that ?
It is your table, so you are the only one who knows what goes into that field.
Ronald :cool:
Ok man
u have real
but realy i don't know
what is ssl_cipher mean
okay
i will try again
thank you
Ok man
u have real
but realy i don't know
what is ssl_cipher mean
okay
i will try again
thank you
It is really simple. You have a private table called 'user'. You obviously have defined this table with columns that have meaning to you, and you alone. So you cannot expect other people to know what should go into that table or its columns.
All I can deduct is that is has something to do with ssl encryption/transfer. Can't you make out from the column metadata what is supposed to be the value and why?
Ronald :cool:
I found some reference to the ssl-cipher in this chapter of the MySQL manual.
--ssl-cipher=cipher_l ist
A list of allowable ciphers to use for SSL encryption. cipher_list has the same format as the openssl ciphers command.
Ronald :cool:
You are welcome. See you next time.
Ronald :cool:
Atli 5,058
Recognized Expert Expert
Hi.
Just a thought...
I might be horribly coffein deprived atm but still...
Are you just trying to add a MySQL user?
If so why not use the CREATE USER syntax?
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: gonzalo briceno |
last post by:
I have been using phplib for a while and I really like the framework
except for form creation. Maybe it is me but I in my opinion there
isn't a good way to create forms or should I say, everything else is
so well done that the way you create forms seems to be too cumbersome,
in particular making it so that a pull down menu selects a value that
you assign it.
In any case, does anyone know of any php based (or other readily
accepted web...
|
by: Michael Iatauro |
last post by:
I've been having a little trouble creating users cross-platform. I have
a little script that works just fine on Solaris 8 using this command:
eval "/path/to/mysql --user=root --password=*****
--socket=/path/to/socket --database=mysql --execute=\"INSERT INTO user
(Host, User, Password, Select_priv, Insert_priv, Update_priv,
Delete_priv, Shutdown_priv, File_priv, Create_tmp_table_priv,
Lock_tables_priv) VALUES ('localhost', 'LocalUser',...
|
by: Ed Brown |
last post by:
I create a database, foo, then designate a user, pooh, with full
privileges, including grant option (pooh is to administer this database,
including creating other users):
grant all on foo.* to 'pooh'@'localhost' identified by 'zoo' with grant
option;
Now pooh logs in to the mysql server, and tries to use his grant option
|
by: Keith Schuster |
last post by:
We just installed mysql 4.0.14 on an xserve. When trying to add users via
mascon I'm finding an issue I have not seen in previously releases. When
adding a user it seems that the new column ssl_cipher is a required field.
I know this is new for v4 but is it supposed to be a required field? What
should the default be? I can't modify any user without being notified that
it is required.
Any ideas?
|
by: Paul K. McKneely |
last post by:
Hi,
I just installed mySQL on MS NT 4.0 workstation and applied Service Pack
6a. When trying to add a new user using the Control Center I get an
info message that say that user was added but this is followed by an
error message that says:
There is no such grant defined for user 'username' on host 'hostname'
Does anyone know what is going on here?
| | |
by: Ken |
last post by:
Hi,
I just upgraded to Mandriva 2005 and I'm having issues
creating users in mysql. I'm doing the user creation
using webmin. I keep getting the following error
"Lost connection to MySQL server during query"
Any ideas? I've never had this problem until now.
|
by: Motoma |
last post by:
This article is cross posted from my personal blog. You can find the original article, in all its splendor, at http://motomastyle.com/creating-a-mysql-data-abstraction-layer-in-php/.
Introduction:
The goal of this tutorial is to design a Data Abstraction Layer (DAL) in PHP, that will allow us to ignore the intricacies of MySQL and focus our attention on our Application Layer and Business Logic. Hopefully, by the end of this guide, you will...
|
by: mramsay |
last post by:
Hi,
I'm having a real problem creating a dynamic hyperlink for my website.
I want to pull the field name from mysql table. Field name is description.
I would like this to be a hyperlink on my homepage. Also, when the user clicks on the description hyperlink they should see a dropdown with other hyperlinks such as hockey, baseball, etc.
Here is what I have so far. I am new to asp and mysql, I would really appreciate the help.
% ...
|
by: DarkGiank |
last post by:
Hi, im new to csharp and im trying to create a class that can change the application database without no rewriting all connection code... but cause some reason it is not working... it tells me that im not creating the object but im doing it,,, please help im a newbie to c#
using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SQLite;
using MySql.Data;
using MySql.Data.MySqlClient;
using...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| | |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
